How to view multiple cells of column data on the same sheet

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.

Answer 1

[Image Analyst]

You can try celldisp() to spit them out to the command window.