How to select values in sequence order?

[Scott]

I have a column of values (up to 144 values). I have several other columns
(up to 12 additional columns) that I want to select those values in the first
column to fill in the rows on the additional columns.

For instance:

Column1
Data1
Data2
Data3
Data4
Data5
Data6
Data7
Data8

Column2
Data1
Data2

Column 3
Data3
Data4

Column4
Data5
Data6

Column5
Data7
Data8



I would think this would involve an INDEX formula, but how would I use it?

Thanks

 

[Dave Peterson]

No headers in row 1, right?

With the data in A1:Axx
Put this in B1:
=INDEX($A:$A,2*(COLUMN()-2)+ROW())
and drag down to B2.

Then select B1:B2 and drag to the right as far as you need.

 

[Scott]

Why would the data come back showing duplicates? For instance, the last one
listed on the 2nd column would be the first in column 3?

 

[Dave Peterson]

I don't know.

Is your data laid out the way I thought it was?