Transpose Columns into Rows

[Faisal___28]

Hi All,

I have a dataset that I need to transpose the columns to rows. I have attached the sample file. 

kindly if you can help me achieve this. Thank you. 

[ShankerV]

Hi @Faisal___28 

This can be achieved with the help of 3 tools.

1. Tile tool

2. Cross tab tool

3. Dynamic rename

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Faisal___28 

Step 1: Tile tool

Tile method: Unique Value

Unique Column: BUH ROR check box to be selected

Step 2: Cross tab tool

Group data by these values: BUH ROR check box to be selected

Change Column Headers: Tile_SequenceNum

Values of New Columns: PRODUCT

Method of Aggregating Values: Concatenate 

Step 3: Dynamic Rename tool

Rename Mode: Add Prefix/Suffix

Select all check boxes except BUH ROR

Properties Add: Product

Many thanks

Shanker V

[Faisal___28]

Thank you so much!!