Copy data from a m x n bunch of cells to a vertical column.

Hey guys,

there is some data in cell L2:Y100

(A rectangular bunch of cells, some cells have data inside, some are blank.)

I would like to massage all the cells that have data into a single vertical column of data.

(Removing the blanks after the data is copied is also acceptable)

How would I do this in VBA???

Hi !

As it depends on which column you need a « massage » (classic, thaļ, … ?!)
but you can clearly use INDEX worksheet function.

Index???

so no need for macro??

I thought index is just for match and index? instead of vlookup?