Convert Rows to Columns with values in Excel using custom format

Question

1

I having a Excel sheet with 1 Merged cell column and 3 subcolumns in that.So I want custom sort the columns and rows on the basis of my format. I have tried using index like this =INDEX(Full!$A$1:$AH$579,COLUMN(A1),ROW(A1)) but this not working in my case so let me the solutions

Eg. I have existing format like this (With values)

Answer 1

Hello :) 
There are a few steps to be followed to convert rows into the columns, that you'll have to follow 

• Select and copy the needed range
• Right-click on a cell where you want to convert rows to columns
• Select the Paste Transpose option to rotate rows to columns