How to realign data in columns to rows?

[Dougie12.]

I have data in cells from Rows 2 to 500 in Column A, I then have some more data in rows 2 to 500 for column B, etc etc unto column M.

I would like it all realigned (not sure if thats the word) so all the data in columns B to M sit under the data in column A in sequential order.

Is there an easy way? a macro or a formula or something that can do this easily in one move?

See attached.

can anyone help me please as I have pages and pages of this to reformat.


Thanks

[DGagnon]

you could use something like this:

Please Login or Register  to view this content.

[dilipandey]

Hi Dougie12.,


Use below quick code:-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Dougie12.]

Guys really appreciate you coming back with the coding, but I really don't know what to do with the code you sent me (beginner you see). Have you sent me some sort of Macro? is it possible to explain what I do with your solutions from a base level please?

Thanks again

[DGagnon]

If you open your sheet and press Alt+F11, this will open the VB editor, you can then right click on the workbook to Insert a new module, paste the code provided into that module and press F5 to run.