2 rows - Same ID - Different contents --> 1 row

[Cedricvm]

Dear all, 

I struggle with an issue. 

As attached, I have for some info, 2 rows with the same ID but different company name. How can I just have one row with an ID an add the info of the second company and company role as two new columns. 

So basically, how can I have just one row for each transaction#key with all the related info of the two previous ones put in columns ? 

Thanks in advance for your help,Regards,

[LordNeilLord · Accepted solution]

Hey @Cedricvm 

You could probably do something really simple like:

Use Summarize to group by and concatenate all of the companies together and then text to columns to split them apart...