Hello Forum,

I am currently working with a dataset that contains 8 columns and 500
rows of numeric data. I need to convert the 8 cols and 5000 rows to
single column which contains all the records (1 column, 40000 rows).
Now I know I could do this by copying each row then past
special/transpose it to a new column row by row, however this will tak
a lot of time with 5000 rows. Does anyone know of doing this using VB
or a formula that would speed up the process?

Below is an illustration of the problem:

From:

A B C D
1 2 3 4
5 6 7 8

To:

A
1
2
3
4
5
6
7
8

Thanks in advance.

Craig

--
Message posted from http://www.ExcelForum.com