Grouping Rows Based on Duplicates, Then Combining Columns

[RonGatmaitan]

I need to combine rows based on whether 3 columns have duplicate values. Then I need to combine those columns' values into 1 column.

Please see illustration below.

I have come across the multi-row tool and iterative macros (though I haven't gone through the details just yet), but I wanna know what's the best and simplest way to do this. I'm fairly new to Alteryx. Thanks in advance, everyone, and more power to the community.

[atcodedog05]

Hi @RonGatmaitan 

It is possible by summarize can you please above sample data in excel.

[atcodedog05 · Accepted solution]

Hi @RonGatmaitan 

Here is how you can do it.

Workflow:

Hope this helps : )

[RonGatmaitan]

Hi, atcodeddog05. Thanks for the quick reply. The sample data is already posted in simplest terms. The From part would be the original data and the To part would be what the data should look like. Thanks again.

[RonGatmaitan]

Wow, that was pretty quick! Let me try it out and get back to you. Thank you!

[RonGatmaitan]

Worked like a charm! Thank you very much!

[atcodedog05]

Happy to help : ) @RonGatmaitan 

Cheers and have a nice day!