Copy a Column as Row headings.
Lets say the column heading are in cells C10 thru C20 (modify to meet your
requirements)
In A1 thru K1 enter:
=C10
=C11
=C12
=C13
=C14
=C15
=C16
=C17
=C18
=C19
=C20
--
Gary's Student
gsnu200707
"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.
|