#1
|
|||
|
|||
Merge duplicate rows but retain data from one column
Good morning,
I am having a problem. I really want to merge duplicate rows in an large Excelfile, butt from the rows that are merged the textdata, which differ, have to be retained in the same merged row. (SEE ATTACHED EXAMPLE ) Hope you can help me with this! (sorry for my English) Kind regards, Willem |
#2
|
||||
|
||||
Your data depict the types as being in column A, with the clubs & cities in columns D & E, leaving columns B & C available. What happens if a club has more than 3 types?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro for Column to Rows Data | brunssl2 | Excel Programming | 3 | 04-28-2014 07:07 AM |
Mail Merge a letter to headmasters with rows of data/students assoc. w/school | sgaeta | Mail Merge | 7 | 04-10-2014 06:34 AM |
Macro to Delete Duplicate Rows and Retain Unique Value | expert4knowledge | Excel Programming | 1 | 02-17-2014 08:02 PM |
mail merge using data from column A as placeholder. | keys | Mail Merge | 2 | 10-31-2013 01:55 AM |
How to send several rows of data from one column to each recipient in one go | mikustykus | Mail Merge | 14 | 09-30-2013 08:32 AM |