How do I pivot a range of cells, i.e. from column to row?

[Ernst]

How do I pivot/transpose the data from a range of cells from, say, a column
to a row? I imagine it should be very simple, but I haven't found out how
yet. For instance:

row#
1 data 1
2 data 2
3 data 3
4 data 4

to

column# 1 2 3 4
data1 data2 data3 data4

[Gary Brown]

Highlight the 2 columns of data, click on Copy, place the cursor, where you want to place the transpossed figures and select Paste special, check the box Transpose.