group and concatenate

[Johmz]

Need help to group data and concatenate if different input

Input

STATE	PRODUCT	SORT
Florida	Apple	Box
Florida	Orange	Bag
Ohio	Apple	Box
Ohio	Apple	Bag
Kansas	Apple	Bag
Kansas	Orange	Bag
Nevada	Apple	Box
Nevada	Orange

Output

STATE	PRODUCT	SORT
Florida	Apple/Orange	Box/Bag
Ohio	Apple	Box/Bag
Kansas	Apple/Orange	Bag
Nevada	Apple/Orange	Box

[apathetichell · Accepted solution]

summarize tool. group by state. concatenate product. concatenate sort. / is your delimiter.

although in your case - it might make more sense to split this up into two streams. do two summarizes in each (group by/group by and then group by/concatenate) (to get each unique sub entry of sort/product) - and then rejoin on state after the concat. you can filter out blank fields if you want prior to concatenating. 

[binuacs · Accepted solution]

@Johmz Multiple summarise tool to remove the deplicates before the concatenation

[Johmz]

Thanks apathetichell. its a big help.

[Johmz]

Thanks binuacs. its a big help.

[HomesickSurfer]

Hi @Johmz 

Perhaps not as slick as @binuacs solution 😎, this may be of interest...but assumes only 2 each of product and sort