Merging rows into the same column

Question

Hi all,

My data looks like this

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

I would like the data to look like this

ProjectPersonPerson 2Person 3Person 4Project 1NickJamesJohnAdamProject 2AdamNickJamesJohn

Thank for your help.

Luke_C · Accepted Answer

Hi @NY2BOS

You could use a summarize tool like this: