O Excel tem a capacidade de fazer isso .
Copy the data in one or more columns or rows.
Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special.
In the Paste Special dialog box, select Transpose, and then click OK.
You'll find theTranspose check box in the lower-right corner of the dialog box:
O artigo vem da ajuda do Excel 2003, mas o processo se aplica até o mais novo Excel. A caixa de diálogo pode parecer diferente.