How to use Transpose option in excel || by Quicklink
1. Select the range of data you want to rearrange, including any row or column labels, and either select Copy on the Home tab, or press CONTROL+C.
Note: Make sure you copy the data to do this. Using the Cut command or CONTROL+X won’t work.
2. Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.
3. Pick a spot in the worksheet that has enough room to paste your data. The data you copied will overwrite any data that’s already there.
4. After rotating the data successfully, you can delete the original data