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)