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

Merge cells dependent on a condition

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]

Want to read more?

Check out the full article on the original site

View original article

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