•1 min read•from 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 [link] [comments]
Want to read more?
Check out the full article on the original site
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