Excel Merging Rows Help
June 23, 2010 1:57 PM Subscribe
I have an excel 2007 spreadsheet that has 4,000 rows and 6 columns of information. Need help merging some of the rows together.....
posted by bleucube to Computers & Internet (10 answers total)
Columns = name, address, primarykey, company, telephone, email
The information comes from two different spreadsheets and I've merged them into one.
Row 1 looks like this:
Bob Smith, ,Atlas, 555-555-1212, firstname.lastname@example.org
Row 2 may look like this:
Bob Smith, 123 Road, smithb, , ,
Some of the information is out of date and I may not have the 2nd row of information.
I basically need to:
Find duplicate names
merge the address and primary key column information into the 1st row and delete the 2nd row