Hi,
I'm currenlty try to create a macro that takes all data in a set number of columns and paste it below each other. I want it to loop this until last populated column.
The number of rows in the sheet can change but is around 300- 400.
Current
ABC111222333444555
ABC111222333444555
End Result
ABC111
ABC111
ABC222
ABC222
ABC333
ABC333
ABC444
ABC444
ABC555
ABC555
Any help would be highly appricated.
Thanks
Bookmarks