When you need to flip-flop data in an Excel 2013 sheet, Transpose option help you with doing it manually. It is available as a special paste option and changes the axis of data arrangement.
How To transpose or switch Excel row or column data in Excel 2013, or vice versa
* Open the spreadsheet you need to change.
* Select the cells containing the data and they should be highlighted. Right-click to select Copy from context menu or press Ctrl + C keys from keyboard. The Cut command is not woking for this.
* Select the top left cell of the your paste location. Right click and select “Paste Special” option or click it from the ribbon. In Paste Special window, check Transpose in the last section and click OK button.