How can I swithc my x and y labels & automatically have the data m
 

I have data from a survey. The question number is on the horizontal x and
the subject number is on the vertical y. I want to switch these two and have
all of the data automatically switch over too. I don't want to have to
re-input all of this data.

Any ideas?

If it fits (limited by only 256 columns).

select the range
Edit|Copy

Select a cell outside this area (new sheet??)
edit|paste special|click transpose

Ric wrote:

I have data from a survey. The question number is on the horizontal x and
the subject number is on the vertical y. I want to switch these two and have
all of the data automatically switch over too. I don't want to have to
re-input all of this data.

Any ideas?

--

Dave Peterson