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 · Accepted solution]

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.

[gautiergodard]

Hi Sammy,

To get the different combinations you could do something like the attached, however I don't understand what the 'Count' column is meant to be counting based on this example - could you confirm? I've included a way to count the unique combinations as a starting point.

**Please like and mark this thread as resolved if this provided an answer to your question**