Transpose

Holla Experts,

I have been working on a project and this module is becoming a big roadblock..

I have to transform the data from one format to another format so that our DBA could transform it to the database.

I want a Generic Macro Program that could be applied to all such data...

The number of rows and columns are variable. And there are no empty rows or columns..

Also the header of the columns are variable..

there is an empty column after the text field (Area) to diffrentiate it with the numeric data of different years.

Please do see the sample sheet attached (with color coding). there are two sheets with names "Original" with the raw data and "Output" with the required conversion.

I am really stuck and I know this is the only place wher i would get help..!!