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