Choose Home→Cells and click the arrow to the right of the Insert button to open the drop-down list for the Insert button.Select the row above or the column to the right of where the insertion should occur.How do I make columns and rows in spreadsheet? Click on the Paste option under the Clipboard section.Then click on any blank cell where you want to see the data.Click on the Copy option under the Clipboard section.Select the whole data and go to the HOME tab.#1 Using Excel Ribbon – Convert Columns to Rows with copy and paste How do I convert columns to rows in spreadsheet? Notice it also moves the horizontal axis to the right. When I check the box, Excel reverses the plot order. There, near the bottom, you’ll see a checkbox called “values in reverse order”. To make this change, right-click and open up axis options in the Format Task pane. Each row is a record of its own, ready to throw into a Pivot Table or work with in your datasheet. Once you’ve clicked on Unpivot Columns, Excel will transform your columnar data into rows. Highlight all of the columns that you want to unpivot into rows, then click on Unpivot Columns just above your data. How do I convert multiple columns to rows in Excel?
Choose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data.Select the range of data you want to rearrange, including any row or column labels, and press Ctrl+C.