List into column heading
 

Hi,

Is there a tool or option in Excel which will allow me to transfer a list in
a column into column headings?

For example, a list with values 1-2-3-4-5 in each row which would be
transferred into 5 columns with headings 1-2-3-4-5.

Thanks.

Isa.

List into column heading
 

One way to get it dynamically transposed from row to col ..

Assuming source data is within A2:A10

Then we could place in say, B1:
=INDEX($A$2:$A$10,COLUMNS($A:A))
and copy B1 across to J1

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Isa" wrote:
Hi,

Is there a tool or option in Excel which will allow me to transfer a list in
a column into column headings?

For example, a list with values 1-2-3-4-5 in each row which would be
transferred into 5 columns with headings 1-2-3-4-5.

Thanks.

Isa.

List into column heading
 

Data/ Text to columns/ delimited/ use the hyphen as delimiter.
--
David Biddulph

"Isa" wrote in message
...
Hi,

Is there a tool or option in Excel which will allow me to transfer a list
in
a column into column headings?

For example, a list with values 1-2-3-4-5 in each row which would be
transferred into 5 columns with headings 1-2-3-4-5.

Thanks.

Isa.