I need to transpose the Row labels in Column A to Row 1 while repeating each row by the number of data coumns.
e.g.
Size Sq ml Population mm Budget $B FY
CityA 40 1 2 July
CityB 65 2 3 Oct
Result seeking:
CityA CityA CityA CityA CityB CityB CityB CityB
40 1 2 July 65 2 3 Oct
Thanks.
Bookmarks