| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort data from rows into columns?
This is probably a stupid question, but I can't figure out the answer using
the Help resources in Excel 2003. I have a worksheet containing records of individuals and events they have attended. Unfortunately, there is a separate row for each person for each event attended, rather than one row per person with the events attended checked off in columns. For example: NAME EVENT John Smith 12/04/2006 John Smith 10/16/2006 John Smith 06/23/2006 Mary Doe 10/16/2006 Mary Doe 04/03/2006 What I want to get to is this: NAME 12/04/06 10/16/06 06/23/06 04/03/2006 John Smith x x x Mary Doe x x How do I do this in Excel 2003? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SORT REPETITIVE DATA FROM ROWS TO COLUMNS | Excel Worksheet Functions | |||
| Sort on rows (not columns) | Excel Discussion (Misc queries) | |||
| How do I sort numbers in a table (ie. rows & columns)? | Excel Discussion (Misc queries) | |||
| Sort multiple rows by data in certain columns | Excel Discussion (Misc queries) | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
Threaded Mode
