Put in B2:
=IF(INDEX($A3:$A300,COLUMN(A1))=0,"",INDEX($A3:$A3 00,COLUMN(A1)))
Copy B2 across as far as required. This will return the results that you're
after.
The range: $A3:$A300 is arbitrary but should suffice here. Adapt to suit if
desired. Note that you'd run out of cols to copy across in xl2003 and lower
(max 256 cols)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"John Gilmer" wrote in message
...
We would like to create an "interaction" matrix.
I would manually enter data in a column. I would want this data
automatically created in column heads.
A B C D
1
2 =A3 =A4 =A5
3Item#1
4Item#2
4Item#3
Since if expect a large number of items, I want to "fill by example" the
rest of row 2. I just can't find out how to do this.
Thanks in advance.