G
giarcsllim
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
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