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.
Solved! Go to Solution.