How to transpose the Excel data in an automate format ?

[PRADEEPB270]

Please refer my attachment.

I my attachment file,have some data,marked in yellow color.

Now,I want to transpose the same as shown in orange color " from cell no. A21.

At present,I am doing this exercise manual and trying to do an automate.But no result that required.

Is it possible to same result through an automate or an excel formula ?

[jindon]

Please Login or Register  to view this content.

[PRADEEPB270]

Thank you sir.

This is an awesome solution and very useful to me.Great help.

[YasserKhalil]

Try this code

Please Login or Register  to view this content.