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