Combine rows based on criteria

[peyton-louden]

Hi all, 

I have  output dataset that needs to be blended to combine some of the rows based on a criteria that must be met. The screenshot below shows how we are receiving the data: 

Basically, if two rows have the Key, the SKU number needs to be combined into one record. For example, row 3 and 4 have the same Key so the SKU would be "91100, 91200." Below is a screenshot of the results:

New to alteryx and don't have a lot of experience combining rows like this so any help would be much appreciated. 

Thanks!

[trsali]

Hi @peyton-louden Use the Summarize tool and group by everything other than SKU Number, then Concatenate SKU Number.

Be sure to change the data type of SKU Number to a string

[Emmanuel_G]

Hi @peyton-louden ,

Find attached the way of doing this.