Hi all!
I've got a small issue concerning a macro in Excel.
I've got a lot of data stored in different columns with different amount of rows (1 column has 100 rows, other has 80 rows for instance). I would like to put all this data into 1 column, instead of copy'ing them one by one . So I'm looking for a formula/macro which takes into account the following things:
- a selection.end(x1Down) per column
- a selection.copy
- go to the new column, find the first empty cell here and paste it below
- go back to original table, go to the next column and repeat the above steps (select all, copy, select empty cell, paste)
- macro should end when there are no more columns
I will post an example file!
I hope you can help me with this, thanks!!
Kind Regards,
VDV
Different columns to one.xlsx
Bookmarks