Inverting worksheet (not graph) axises

[RiotLoadTime]

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

 

[Guest]

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...

 

[Gord Dibben]

Try Copying the range then Edit>Paste Special>Transpose.

Note: you cannot overlap any of the existing rows and columns.

I would Paste to A1 in a new worksheet.


Gord Dibben MS Excel MVP

 

[Ragdyer]

Do you realize that would mean that you'd only have room for 56 more
patients?

You could select all your data, A1 to IV200,
Right click in the selection and choose "Copy",
Then right click in the cell that would be the top left cell of your *new*
location,
Choose "Paste Special",
Then click on "Transpose",
Then <OK>.

NOW ... there can be *no* overlap of the old and new locations.
This means you would start at *least* in A201,
OR
You could simply right click in A1 of a *new* sheet, and transpose there.

 

[Guest]

Hi,

I am needing to do a similar thing to what this topic is about. I have
tried the transposing option and that works fine for the static data. I am
needing people to update the data in the original sheet. The reason I am
needing to transpose the data is then to mailmerge it using the original rows
(transposed) to columns as the data record. Is there a way to transpose the
data with it linking back to the original data or is there an easier way to
get it to merge properly?

Nikki

 

[RagDyeR]

This procedure takes *1* column and transposes to *1* row.

I'm sure that you want your *single* data column to transpose into 3 or 4 or
5 field columns, and numerous item rows ... right ?

If I misunderstood what you're looking for, then this type of formula will
take the data from Column.A on Sheet1, and transpose it to a single row on
another sheet,
AND create (maintain) links to the original data.

=INDEX(Sheet1!$A:$A,COLUMNS($A:A))

Copy across as needed.

Don't forget that at *present*, this will only work for 256 rows, since you
only have that number of columns.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi,

I am needing to do a similar thing to what this topic is about. I have
tried the transposing option and that works fine for the static data. I am
needing people to update the data in the original sheet. The reason I am
needing to transpose the data is then to mailmerge it using the original
rows
(transposed) to columns as the data record. Is there a way to transpose the
data with it linking back to the original data or is there an easier way to
get it to merge properly?

Nikki