Column to Array

D

doneagle

I have spent HOURS on this...

Very simple, all I need to do is convert a column of about 1600 items
to an array 12 items wide.
Help???
 
H

Harlan Grove

[email protected] wrote...
....
Very simple, all I need to do is convert a column of about 1600 items
to an array 12 items wide.
Click to expand...

1600 isn't divisible by 12. I'll assume there are 1608 items. I'll
assume your column of data is named D.

For what purpose? If you just want to fill another range that spans 12
columns by 134 rows (I'll use G1:R134). If you want to go across then
down, use

G1:
=INDEX(D,1)

H1:
=INDEX(D,COUNTA($G1:G1,1))

Fill H1 right into I1:R1.

G2:
=INDEX(D,COUNTA($G$1:$R1,1))

H2:
=INDEX(D,COUNTA($G$1:$R1,$G2:G2,1))

Fill H2 right into I2:R2. Then fill G2:R2 down into G3:R134.
 
D

doneagle

This did not work for me. It returned an error: #NAME?

THe data is an export from a program and has 12 properties for each
item. That is why i need to get it in an array, so I can analyze
properties for each item.
 
H

Harlan Grove

[email protected] wrote...
This did not work for me. It returned an error: #NAME?
Click to expand...

I stated that I was assuming your original data range was named D. Did
you either use Insert > Name > Define to name your data range D or
replace D in my formula with the actual range address of your data
range?
THe data is an export from a program and has 12 properties for each
item. That is why i need to get it in an array, so I can analyze
properties for each item.
Click to expand...

So if everything were in a single column, then item1 property1 would be
in the topmost cell, item1 property2 in the next cell, . . ., item1
property12 in the 12th cell, item2 property1 in the 13th cell, etc? If
so, then either name your data range D and use the formulas from my
previous response, or change D in those formulas to the actual range
address (make it an absolute reference) of your original data.
 
H

Herbert Seidenberg

Since, as Harlan noticed,
....1600 isn't divisible by 12...
and the data was imported, probably as text,
I suspect that the data is in the format
item1, prop1, prop2, prop3...., prop12
item2, prop1, prop2, prop3...., prop12
In that case use
Data > Text to Columns
 
Top