View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.