rotate data from x axis to y axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Willc - 06 Oct 2006 01:27 GMT

Hi everyone:

if i have some number at column and i want to switch all the numbers to
vertical in one times,how can i do this.

For example : i have 1 at A1 cell, 2 at Number at B1 cell and 3 at C1
cell, how can i switch/rotate all my data to A1/A2 and A3 cell?

Reply to this Message

Gord Dibben - 06 Oct 2006 02:02 GMT

Copy A1:C1 then select a cell out of the copied range and Paste
Special>Transpose>OK>Esc

Gord Dibben MS Excel MVP

>Hi everyone:
>
[quoted text clipped - 3 lines]
>For example : i have 1 at A1 cell, 2 at Number at B1 cell and 3 at C1
>cell, how can i switch/rotate all my data to A1/A2 and A3 cell?

Reply to this Message

Max - 06 Oct 2006 02:03 GMT

Copy A1:C1, then right-click on A2 > Paste special > Transpose > OK.
Then delete row 1.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi everyone:
>
[quoted text clipped - 3 lines]
> For example : i have 1 at A1 cell, 2 at Number at B1 cell and 3 at C1
> cell, how can i switch/rotate all my data to A1/A2 and A3 cell?

Reply to this Message