Question: how to transfer data in row to column in excel?
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.