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" wrote:

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 wrote:

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