"Dave Peterson" wrote in message
...
You may want to look at the =transpose() function.


OK.

I will check it out.

Clearly I am creating a square matrix and matrix operators might be useful.

Thanks again
If your headers are in A1:A10 (10 cells)
then select B1:K1 (10 cells, too)
Type this formula:
=transpose(a1:A10)

but hit ctrl-shift-enter instead of just enter to fill that horizontal
range.

John Gilmer wrote:

I would like to copy a column list as row headings. I would prefer
that a
formula be copied and modified to do that job so that when I change a
value
in the column of entries, the row heading is changed automatically.

Thanks in advance.

--

Dave Peterson