View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BCLivell BCLivell is offline
external usenet poster
 
Posts: 12
Default 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