Code to transpose a data

[Kiran Mambi]

Hi everybody
How are you?

I am stuck up at one place and need the solution.
The data is in sheet1
The required result is in sheet2
The actual data in sheet1 can be of any number of rows.

Thanks
Kiran

[sktneer]

Please find the attached sheet to see if this is what you are trying to achieve.

[oeldere]

@Sktneer

Maybe you could also post your code (in the future) so other forummembers don't have to open the file.

[venkat1926]

copy sheeet1 to sheet3 to preserve original data

try the macro test

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Kiran Mambi]

Thanks sktneer
the code is working fine and as required.

I would also request venkat1926 to give a sample file since there are two codes.

Thanks again

however the querry is solved but I am waiting for venkat's reply.

[sktneer]

You're welcome. Thanks for the feedback and rep.