Merging rows into the same column

[NY2BOS]

Hi all, 

My data looks like this

Project	Person	Person 2	Person 3	Person 4
Project 1	Nick
Project 1		James
Project 1			John
Project 1				Adam
Project 2	Adam
Project 2		Nick
Project 2			James
Project 2				John

I would like the data to look like this

Project	Person	Person 2	Person 3	Person 4
Project 1	Nick	James	John	Adam
Project 2	Adam	Nick	James	John

Thank for your help.

[Luke_C · Accepted solution]

Hi @NY2BOS 

You could use a summarize tool like this: