Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose certain data
Hi eeryone-
I have excel data where is lists a person on a new row for each project they work on. Fro example: ID Name Project Name 101 Person 1 Project 1 101 Person 1 Project 2 101 Person 1 Project 3 102 Person 2 Project 1 102 Person 2 Project 3 I need to figure out a way to get the data to look like this: 101 Person 1 project 1 project 2 project 3 102 Person 2 project 1 project 3 ect... Each person has their own unique ID number. Please help. thank you very much! -Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inconsistent Sorting | Excel Discussion (Misc queries) | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Hi all i need some help on excel transpose | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
How do I repeatedly transpose blocks of data? | Excel Discussion (Misc queries) |