Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining/Merging Rows
I have a spreadsheet with 9500 rows of data.
The rows look like this: 305-129, Bill, Smith, $50 305-129, Bill, Smith, $250 305-129, Bill, Smith, $100 005-277, Mary, Maze, $100 005-277, Mary, Maze, $500 I need the rows to look like this: 305-129, Bill, Smith, $50, $250, $100 005-277, Mary, Maze, $100, $500 There are many more columns, but thats the idea. I need to merge all the rows so that each person with their unique ID number has the entire string of information in one row. Right now for every donation, the person has a row, so one person with 10 donations has 10 lines. I need all 10 donations in the same row. Any help would be greatly appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Excel files into 1 (no merging) | New Users to Excel | |||
Combining / Merging several rows - but want to keep formatting | Excel Discussion (Misc queries) | |||
Merging Data in Different Rows | Excel Discussion (Misc queries) | |||
Merging rows | New Users to Excel | |||
Merging Two Rows Into One | Excel Worksheet Functions |