How to convert Vertical into Horizontal

[Subha M]

Hi All,

I would be greatful if somebody would suggest me how to arrive the required values from one sheet to another also from vertical to horizontal.Herwith
attached the excel which would explain in better way
Please help me!!!!!!!!!!!!!!!!!!!!!!Required format.xlsRequired format.xlsRequired format.xls

[samba_ravi]

See the attached file
you can do it by using pivot table too

[Subha M]

Thank you so much ,It works well

[samba_ravi]

Thanks for your feedback