Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving duplicate data in rows to columns with same name
I have a worksheet with 3000 rows - Each row is a unique entry but
every 4 or 5 rows belong to the same person. Name Test Score Bob Math 100 Bob English 95 Bob Science 85 Sue Math 54 Sue English 87 Sue Science 100 What's the best way to take the data from someone's row 3 and 2 and get them into columns for their row 1? The way I'm doing it is clearly not the fastest! Any help would be appreciated - thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving duplicate data in rows to columns with same name
Consider using pivot table, I used it on your data, here is how it looked:-
Name English Math Science Grand Total Bob 95 100 85 280 Sue 87 54 100 241 Regards, Sherin "Jennifer B." wrote: I have a worksheet with 3000 rows - Each row is a unique entry but every 4 or 5 rows belong to the same person. Name Test Score Bob Math 100 Bob English 95 Bob Science 85 Sue Math 54 Sue English 87 Sue Science 100 What's the best way to take the data from someone's row 3 and 2 and get them into columns for their row 1? The way I'm doing it is clearly not the fastest! Any help would be appreciated - thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving duplicate data in rows to columns with same name
Thanks Sherin - I need to export the data into a graphics program and
I don't seem to be able to do that with a Pivot table. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Highlight Two Rows With Two Columns of Duplicate Values | Excel Worksheet Functions | |||
Eliminate Duplicate Rows - Add columns Accordingly | Excel Discussion (Misc queries) | |||
Moving rows to columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Moving columns into rows | Excel Discussion (Misc queries) |