Help with a macro to combine rows in a spreadsheet

**theatergirl** · 05-07-2013, 01:18 PM

I have a spreadsheet that I need to combine the rows based on a common customer number. Attached is a sample of the spreadsheet. Any help or directions on how to combine would be much appreciated.

Thanks!

**AB33** · 05-07-2013, 01:49 PM

Unless you want to add match using a delimiter, A Pivot table should do it.

**AB33** · 05-07-2013, 01:54 PM

Sorry!
I did not see you have a desired result at the bottom of the data. Why Bob has two rows?

**theatergirl** · 05-07-2013, 01:57 PM

there shouldn't be - updated sample spreadsheet attached.

thanks!

**theatergirl** · 05-08-2013, 06:15 PM

Did the new spreadsheet make sense?

Thanks

Help with a macro to combine rows in a spreadsheet

LinkBack

Thread Tools

Rate This Thread

Display

Help with a macro to combine rows in a spreadsheet

Re: Help with a macro to combine rows in a spreadsheet

Re: Help with a macro to combine rows in a spreadsheet

Re: Help with a macro to combine rows in a spreadsheet

Re: Help with a macro to combine rows in a spreadsheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions