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
|