Excel transpose/cross tab based on same column values

[Distribution]

Hi, I am not sure if anyone else have asked some similar questions, if there is please kindly refer me to it to save some time.

I was trying to transpose the excel table (left format) to the right side, criteria is based on the values of column A & B.

If column A & B have exact same values, transform column C and put values into new column, as shown in the screen capture.

I know this should not be too difficult but I am still very green to Alteryx and wish someone could help.

Thanks!

Max

[ShankerV · Accepted solution]

Hi @Distribution 

This can be achieved by the following steps.

Step 1: Tile tool

Tile Method: Unique value

Unique Column: Select Spec Type and Value check box

Group by columns: Select Spec Type and Model check box

Step 2: Cross tab tool

Group data by these values: Select Spec Type and Model check box

Change Column Headers: Tile_Num

Values for New Columns: Value

Method of Aggregating Values: Concatenate

Run the workflow to get your desired result.

Many thanks

Shanker V

[Qiu · Accepted solution]

@Distribution 
This can be achived by combination of Tile and Cross Tab tools as below.

[Distribution]

Hi Shanker and Qiu,

It works! Thank you both for your quick response and kind help!

Thanks,

Max