Crosstab or similar

Sammy22

i need to convert data on the left into the right table which will show how many of each combinations there are. not sure how to go about this!

Order	Type		Combination 1	Combination 2	Count
Bread	white		white	wholemeal	2
Bread	wholemeal		white	white	1
Bun	white
Bun	white
Baguette	white
Baguette	wholemeal

JamesCharnley

You should be able to achieve this with a combination of creating a tag, and then aggregating. My multi-row tool is grouping together the order, then the first summarize is concatenating the types, before the second summarize can count, and lastly splitting the concatenation back into its own columns.

ConcatCountBread.yxmd