Right-click into the cell where you would like to copy your data. Click on the arrow next to Paste Special and then click on the Transpose icon. Your data has now been transposed and is ready to work ...