Zellen invertieren (Zeilen+Spalten vertauschen) in Excel

 

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.

Convert columns to rows, or rows to columns 

(invert, transpose, swap columns and rows)