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

Cedricvm — Mon, 13 May 2019 12:12:50 GMT

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,

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

LordNeilLord — Mon, 13 May 2019 12:20:23 GMT

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

topic 2 rows - Same ID - Different contents --> 1 row in Alteryx Designer Desktop Discussions

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

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