How to select values in sequence order?


S

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
 
Ad

Advertisements

D

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.
 
S

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?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top