Take used cells in column B and add under column A... then on to last used column.

[Wales MB]

I have a large amount of data spread over an ever changing number of rows and columns.

I need to cut the data from column B and add under the data already in column A, then go to column C cut the data and add under column A....... then on and on until there is no data left in any other column but A.

I have started but neither examples will work........ and then how do i tell it how many rows and columns have data in......

Please Login or Register  to view this content.

Please Login or Register  to view this content.

HELP......

[stnkynts]

Try:

Please Login or Register  to view this content.

[Wales MB]

Yes yes yes - Thank you.

I don't understand it but thank you...