manipulating the data

LoisGower

hey team,

I need your brains please!! 

I have tried using the cross tab and I just can't get it to work.

This is the raw data;

Customer no	Style Description	Size
1234	Hoodie Orange	L
1234	Hoodie Green	L
1234	Hoodie Orange	M
2345	Jeans	M
2345	Polo Blue	S
2345	Polo Blue	S

And I want to turn into this;

Customer no	Style Description	Size	Style Description	Size	Style Description	Size
1234	Hoodie Orange	L	Hoodie Green	L	Hoodie Orange	M
2345	Jeans	M	Polo Blue	S	Polo Blue	S

and then do some sort of formula to identify if the customer has brought the same product in the same size. So in this example 2345 the blue polo in size S small would be want I wanted to highlight some how.

Any suggestions / flows would be amazing.

Many thanks,

Lois. 

Jean-Balteryx

Hi @LoisGower ,

Here is how you can do it for the cross tabs part ! Fields can't have same name so I added an ID.

cross_tab.yxmd