I have 357 cells, each containg a column of data of different lengths. I want to add all these columns to the same sheet but I can't find a way to open them all into one sheet and each pops up as a different tab. I'm not sure if there is a simple way to view all the data on one sheet or whether I would need to add them into a matrix with a loop and pad them out with zeros, as the columns are all different length, although I wouldn't really know how to do this?
I can't find anything on how to add all the columns and view all the data on a single sheet but I'm sure there has to be an easy fix.
I greatly appreciate any help.