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

R

Ric

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?
 
D

Dave Peterson

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
 
Top