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

Question

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 Answer

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...