Question: how to transfer data from column to row?
Answer: Select the range of data you want to rearrange, including any row or column labels, and either select Copy. ...  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.