VBA to copy data in the columns to row A

[maryflower]

Dear experts
I need a help in writing a code that allows me to copy data from the column B to Column BBE and paste in Column A, row wise. I have information as below

Please Login or Register  to view this content.

I would like to keep my data as below after running macro

COLUMN A

Row1 003
Row 2 443
Row 3 851A
Row 4 blank row
Row 5 465
Row 6 376
Row 7 346
Row 8 097
Row 9 blank row
Row 10 234
Row 11 123
Row 12 456
Row 13 345
Row 14 087
Row 15 456
Row 16 987
Row 17 534
Row 18 blank row
Row 19 567
Row 20 678
Row 21 098
Row 16 445
Row 17 098
Row 18 345 and

So on till Column BBE. Right now am manually cutting the columns and pasting in Column A but i have huge set of data which makes the job little time taking.

Thanks a lot

[Akuini]

Try this:

Please Login or Register  to view this content.

[maryflower]

Dear Akuini,

Sorry for the late reply. This is just what I was looking for. Thank you so much!

[Akuini]

Dear Akuini,

Sorry for the late reply. This is just what I was looking for. Thank you so much!

You're welcome & thanks for the feedback