I have an excel workbook (1 sheet). The sheet contains over 1000 columns with a lot of data. All columns are different, one can have 20 rows, another 10 rows, other 55 row etc. (maximum column length reaches 400th row). Is there a function or macro that will combine all of this data into one vertical column without having to individually cut and paste each one into the new column?
Bookmarks