1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Merge cells dependent on a condition

Our take

To effectively merge cells in Excel based on specific conditions, you can follow a straightforward approach. In your dataset, where the "name" is missing, you can populate it with the corresponding "company" name if it exists. Start by selecting the range of data, then use a formula to check if "name" is blank. If it is, replace it with the "company" value. After making these adjustments, ensure your spreadsheet retains only the "uniqueid," "name," and "email" columns before exporting to CSV.

teat me as a beginning beginner pre-beginner level user

4 columns - uniqueid, email, name, company

I will export to CSV and can import only the first 3 into the program.

Before exporting, within Excel, how would you attack this :

Where name is missing, populate it with the company if it exists

uniqueid,name,email,company 00011,CindyLou Who,cwho@company.tld, 00012,,grinch@company2.tld,Grinchdom 00013,,sally@company3.tld, 00014,Patrick,pat@spongebob.tld,Spongey 00015,,bob@spongebob.tld,Spongey 

desired:

uniqueid,name,email 00011,CindyLou Who,cwho@company.tld 00012,Grinchdom,grinch@company2.tld 00013,,sally@company3.tld 00014,Patrick,pat@spongebob.tld 00015,Spongey,bob@spongebob.tld 
submitted by /u/GeekgirlOtt
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Related Articles

Tagged with

#Excel compatibility#Excel alternatives for data analysis#no-code spreadsheet solutions#Excel alternatives#rows.com#enterprise-level spreadsheet solutions#financial modeling with spreadsheets#Excel#CSV#uniqueid#email#name#company#import#export#populate#missing#conditional#data manipulation#cells