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