combining data from different rows into 1 column

J

Jim Linnenburger

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help with restructuring a form 2
Reformatting a data table 4
moving duplicate data in rows to columns with same name 2
Copy rows to new sheet based on value in column A 0
Combining data from multiple rows 2
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns 1
HELP: Populate Excel FORM from Access - Pull from multiple rows 3
create additional rows containing data from one original row 0

Top