"Gary''s Student" wrote in message
...
I see your point. In A1 enter:
=INDIRECT("C" & COLUMN()+9)
and copy across. This is only one formula rather than many.


The +9 is a bit artificial and will need to be adjusted if the list does
not
start in C10

OK.

That's a start.


I may have some questions down the line.

For example, were I to want to sort the rows via the "key" entry, that would
automatically change the column heads. BUT the data corresponding to the
cross points would no longer be in the right place.

But I will look into that "some other time."

Thanks, again.

--
Gary's Student
gsnu200707


"John Gilmer" wrote:


"Gary''s Student" wrote in
message
...
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


That's what I have been doing.

I'm VERY lazy (and somewhat geek oriented) so I want the C3....C50
entries
to be made automatically. Aside from saving work it will also reduce
the
chance of a data entry error.