A B C D E
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
You have a data array of numbers appearing in columns A - E. The numbers appear in the order indicated above. The data array can vary from 1 to 7000 numbers depending on data downloaded to Excel. Therefore, the data will appear from Row 2 to possibly Row 1400. The goal is to place the numbers in order of appearance down a single column.
For instance if the results were to appear in column G the would appear in the following cell reference order:
A1
B1
C1
D1
E1
A2
B2
C2
D2
E2
A3
B3
C3
D3
E3
.
.
.