More information is needed. Is there a header row? If so, what do you
want to become of it? Might the be empty cells within the table? How
do you recognize how many columns are used, or is the first row always
filled for each column? If one of the products uses 17 rows, will all
of the products use 17 rows? What do you mean by "the original order"
when you are combining multiple columns into one colum; would
a b c
d e f
g h i

become
a
b
c
d
...
or
a
d
g
b
...

Jerry

Prixton wrote:

Hi,

We get a lot of information that comes into different columns, say Product
1 - 88. We never know how many values there are in every colum or how many
Products there are

Now we want a macro that puts all the values into one column, say A - can be
in sheet 2. We do not want empty rows or columns but it is very important
that the figures are in the original order.

Regards