View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Copy Column to Row

Check your other post, too.

John Gilmer wrote:

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.


--

Dave Peterson