How do you swap table axes?

[Tali]

Is it possible to swap the axis of a table SO that the columns become the rows and vice versa?
I tried using the pivot table function, but it gives total sums and other stuff that i dont want.

HELP!

 

[XL-Dennis]

Tali,

Welcome to the board

You question is a little bit unclear to me so start to explore the function TRANSPOSE and see if it can help You.

HTH,
Dennis

 

[Tali]

Hi Dennis,

I had a look at the transpose function and basically thats what i want to do..but with a whole table instead of just one coloumn.

I know i wasnt very clear, so heres an basic example of what i want to do.

The originial table looks like this:

A B C
1 2 3
1 2 3
1 2 3

but i want to change it to this:

A 1 1 1
B 2 2 2
C 3 3 3

without manually doing it by 'drag and drop'.

Is it possible to do this?

I hope this is clearer!!

Thanks again,

Tali

 

[Parra]

COPY the data, Edit > Paste Special and choose the Transpose Option, It should be at the bottom of the pop up screen and choose OK.

It should give you what you want.