Macro to reformat data in horizontal format to a proper Data table

hi
Please help me with a macro to reformat the data as described in the attached worksheet.

I need to convert the data from horizontal format to a proper data table.

The month headings can change and some times the file may not start with January as the first month

thanks

Try the code and make sure you have back up file.

Please Login or Register  to view this content.

Jindon
thanks a ton. You are a genius.
It works like a charm