How to Combine Rows Based on Criteria

[peyton-louden]

Hi all, 

I have a dataset that  I'm trying to blend to combine rows based on a certain criteria that I've identified. The following screenshot shows what my data looks like: 

Basically, if two rows have the same KEY then the rows need to be "combined" by putting the SKU Numbers in the same record. For example, lines 3 and 4 having matching SKU Numbers. To combine them, row four would be deleted and the SKU Number on row three would read like "91100, 91200" to reflect the combination. 

Below is a screenshot of the desired result:

Seems like an easy task but having trouble wrapping my head around it so any assistance would be appreciated it. 

Thanks!

[DavidSkaife · Accepted solution]

Hi @peyton-louden 

I think this is what you're looking for: Change the SKU Number to a string, group by all fields except for SKU Number which you need to concatenate:

Edit: this does assume all your other fields are identical as well, not just the Key field

[Emmanuel_G]

Hi @peyton-louden ,

Find attached the way to do that.

[peyton-louden]

This was exactly what I was looking for. Thanks!