Most of the times you have to rebuild the Excel worksheet so that the rows are converted into columns and columns are converted into rows. If you copy and paste the data to rebuild the Excel table manually, then it will consume more time. In case you have a large data range, then it is impossible to do this procedure manually. Don’t worry; MS Excel has that feature which will do this procedure automatically. So, here’s how to change data from rows to columns in Excel.

Source: How to Change Data from Rows to Columns in Excel