Transforming a column to a row

[hanswang09]

Hi, 

I have a simple question on transforming the data. This is the input format. 

Customer ID	Date	Product
1	11/16/2015	A
1	11/16/2015	B
1	11/16/2015	C
1	11/16/2015	D
1	11/16/2015	E
1	11/16/2015	E
1	11/16/2015	F

And I want to transform/transpose SKU from a column to a row, which will look like this. 

Customer	Date	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6
1	11/16/2015	A	B	C	D	E	F

I am not so familiar with transpose functions so any help is much appreciated. 

Thanks, 

[pcatterson · Accepted solution]

The thing you need is a Cross Tab tool to accomplish this.

[jack_morgan]

Hey there!

Attached is a sample!

Thanks!

Jack

[danielbrun2]

Hi,

I am not quite sure what you are trying to achieve, but the attached workflow might point you in the rigtht direction.

I think what you are looking for is crosstab and not transpose.

Best,

Daniel

[hanswang09]

Thank you very much for all your help. It works great. 

Best, 

Han