Convert horizontal date into Vertical date

Hi

I am new to this forum and new to Macro

I am attaching a file where horizontal row should be converted into Verticle Row


Can you pls help me with it

thanks a lot in advance

Hello,

By hand :
1) select range A1:AX3 and copy
2) select A1 in new worksheet and menu Edition/Pastespecial checkbox Transpose

By macro :
Copy this code in a standard module

Please Login or Register  to view this content.

Best regards.

PMO
Patrick Morange