vba code for Transpose past special from col to rows- Insert serial No

HI
I am attaching excel file which contains cost sheet of each flat.
I would like to copy from sheet to sheet Index from colums to rows

In the next sheet index macro shall insert sn col and no of rows for each and every Head and transpose value from col to rows.
I basically try it out for making combo box for each and every item for filtering purpose.

Any can help me out for this.

A sample file is attached
Thanks & REgard

Hi
Atleast if somebody can help me out copying the colums to row will be sufficient.
Code should be dynamic enough to handle any number of colums to rows
Seria nO colum is also not required.
Any body help me out on this.
Thanks & Regards