Reverse of Transpose (Columns to rows and vice-versa)

[avisingh96]

Hi Community,

I want your help in this thing. I want to convert the column headers to rows and the 1st row fields to columns. Basically Columns to rows and row data to columns. I have attached a Sample file in which a Sample input is in the 1st sheet and my desired output is in Sample Output.

Please help.

FYI - Cross Tab is not working the way I want. If you have any configuration in Cross Tab that can help. Please let me know

[npariso]

Hi @avisingh96 a combination of the transpose and crosstab tools will get you the correct solution.

[binuacs]

@avisingh96 Similar to @npariso solution

[nagakavyasri]

Similar solution: