Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolodate Data from Multiple Rows into One Row
I have class data for students with each class for each student on a separate
row. To import into a program I need a list with one row for each student with all classes on that row. How can I do this? For example starting with this: Student Class Jones English Jones Math Smith Geography Jones Geography Smith Math I need to rearrange to this: Student Class Class Class Jones English Math Geography Smith Geography Math Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
Import data and keep duplicate rows of data | Excel Discussion (Misc queries) | |||
output date modified if data is entered for multiple rows | Excel Discussion (Misc queries) | |||
How can I convert a data from multiple rows into 1 column? | Excel Worksheet Functions | |||
how do I insert multiple rows in excel after every row of data | Excel Discussion (Misc queries) |