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

.

.

.

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

.

.

.

## Comment