View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jennifer
 
Posts: n/a
Default Inverting worksheet (not graph) axises

Use a Pivot table - the wizard is very easy to use and will let you move your
data around. You find it under "data" menu...

"RiotLoadTime" wrote:


I have an 256 column X 200 row worksheet filled with patient data.
Right now, each row is a different patient number, and the columns are
the various types of data that I've recorded for those patients. For
data-input reasons, I'd like to switch it so that the different data
types are on the rows and each patient gets his/her own column. Is
there an easy way to do this?

Thanks,
RiotLoadTime


--
RiotLoadTime
------------------------------------------------------------------------
RiotLoadTime's Profile: http://www.excelforum.com/member.php...o&userid=35956
View this thread: http://www.excelforum.com/showthread...hreadid=557462