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

Transpose certain data
 

Let's say your header from A1 to C1
A2:A6 = ID
B2:B6 = Name
C2:C6 = Project Name

and you want to look for...
101 in E2
102 in E3
In F2 =VLOOKUP(E2,$A$2:$B$6,2,0)
In G2
=IF(ISERR(SMALL(IF($A$2:$A$6=$E2,ROW(INDIRECT("1:" &ROWS($C$2:$C$6)))),COLUMNS($A:A))),"",INDEX($C$2: $C$6,SMALL(IF($A$2:$A$6=$E2,ROW(INDIRECT("1:"&ROWS ($C$2:$C$6)))),COLUMNS($A:A))))

Formula in G2 is an array formula you have to commit ctrlshiftenter (not
just enter)
copy as far as suite your need




"BCLivell" wrote:

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