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

smartin

Scott said:
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

Possibly anywhere in B1:E2
=INDEX($A$1:$A$8,(COLUMN()-2)*2+ROW(),1)

This can be tricky because the exact formula (especially the row
parameter of INDEX) highly depends on exactly where the data and results
are placed. Hopefully you get the idea though.
 
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?
 

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