| 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! |
| 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) | |||
Threaded Mode
