| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolodate Data from Multiple Rows into One Row
Probably long winded but for a quick solution I would use auto-filter to
isolate data by the individuals name, then copy the lessons from the list and paste-special-transpose against the name. Its long winded because you have to do this for each student. Sorry can't think of a smarter way ! "Doug Randall" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Consolodate Data from Multiple Rows into One Row
Unfortunately, I can have up to 3000 students in the file, so I need an
automatic solution. "Dreid" wrote: Probably long winded but for a quick solution I would use auto-filter to isolate data by the individuals name, then copy the lessons from the list and paste-special-transpose against the name. Its long winded because you have to do this for each student. Sorry can't think of a smarter way ! "Doug Randall" wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
