We can convert the values in each row of the same column to different columns of the same row.
We can transform the items in one of those rows into columns (or vice versa). It would take a lot of time to copy and paste each individual header — but the transpose feature allows to do it simply move the row data into columns, or column data to rows.
Select the values that are to be converted. Copy that and click on the cell where the first cell of the columns to begin
Right-click on that cell and select the “Paste Special” option
Select the “Transpose” option and Click “OK”
Then the values will be arranged in each column.
In the same method, we can convert the values in the columns to single rows.