| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining data from different rows into 1 column
I am trying to adjust an excel spreadsheet to take multiple rows that involve
the same ID number and merge them onto a single row. For example, the sheet that I am given will have data in this format: 93900 30303E Math 93900 40404E English 93900 50505E Science 94911 30304E Math II 94911 40405E English II 94911 50506E Science II Where the first column is the ID number, the second column is the section number and the third column is the class description. I am trying to get the data into this format: 93900 30303E Math 40404E English 50505E Science 94911 30304E Math II 40405E English II 50506E Science II where each row combines the section numbers and course descriptions for similar ID numbers. Does anybody have any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining two rows of data into one (Not Concatenate) | Excel Discussion (Misc queries) | |||
| Combining rows with similar data | Excel Discussion (Misc queries) | |||
| Combining rows of like data? | Excel Worksheet Functions | |||
| combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
| Combining rows of data that have one cell in common | Excel Discussion (Misc queries) | |||
Hybrid Mode
