| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I combine rows, combining duplicates as well as concatenati
I'm trying to combine rows of data and I need a certain column to concatenate
only if it is in a group of rows that have duplicate information in another column. Example: Before... Column 1 Column 2 X A X B Y C Y D Desired After... Column 1 Column 2 X AB Y CD This is for a spreadsheet with thousands of rows Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| Find duplicate rows then deleting them | Excel Worksheet Functions | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Threaded Mode
