Align the data vertically from Horizontal layout

Hi,
I have a certain data, currently in Horizontal layout which I want to present vertically. Simple transpose of data is not what i am looking for.

Branch PROD NAME ID SL.NO CAT Jan Feb Mar
AHD AV AMMA 09543898 2 PDP 0.2 0.1 0.2
AHD AV AMMA 09543898 1 LED 1.4 1.5 1.8
AHD AV AMMA 09543898 3 VCD 0.0 0.0 0.0
AHD AV AMMA 09543898 4 HTiB 0.0 0.0 0.0

I want to present the above data in this way:

Branch PROD NAME ID SL.NO CAT Jan
AHD AV AMMA 09543898 2 PDP 0.2
AHD AV AMMA 09543898 1 LED 1.4
AHD AV AMMA 09543898 3 VCD 0.0
AHD AV AMMA 09543898 4 HTiB 0.0

Branch PROD NAME ID SL.NO CAT Feb
AHD AV AMMA 09543898 2 PDP 0.1
AHD AV AMMA 09543898 1 LED 1.5
AHD AV AMMA 09543898 3 VCD 0.0
AHD AV AMMA 09543898 4 HTiB 0.0

Branch PROD NAME ID SL.NO CAT Mar
AHD AV AMMA 09543898 2 PDP 0.2
AHD AV AMMA 09543898 1 LED 1.8
AHD AV AMMA 09543898 3 VCD 0.0
AHD AV AMMA 09543898 4 HTiB 0.0

Is there a way we can achieve this? I have around 1000 rows of data for a year, which i have to present in this fashion. Kindly help on the above.
Regards,

Can you post a workbook? I could write a macro that rearranges the data.

hi itsmesunilb, option, please check attachment press Run button or run code "test"

Another solution: try running this macro when the active sheet is the one you want to rearrange.

Please Login or Register  to view this content.

Thanks for the reply. It worked for me. thanks a ton..!!