Column into row

[juicydeuce]

I have two sheets which contain relative data.
My problem is that the columns and rows on the two sheet are
exact turned around so that from the columns in sheet 1 are
rows in sheet 2, and the rows in sheet 1 are columns in sheet 2.

What I wish to do is to from one of the sheets I want to turn
it around so that columns match columns and rows match rows.

I would appreciate if someone could tell me how to solve this
problem. Generally, I would try to go though the help menu in
the excel but I am in the office and the excel is in German.
I don't speak German that well to conduct proper search in the
help menu here.

Thanks a lot in advance.

juicydeuce in Germany

 

[cherria]

Copy one of the tables then go to Edit->paste special -> click the transpose check box and paste (should probably insert a new sheet and paste into that)

 

[Richie(UK)]

Hi jd,

Welcome to the board.

Have you tried Copy - PasteSpecial - Transpose?

If its more complicated than that then we will need some more detail.

HTH

 

[juicydeuce]

Thanks a million!