It’s not the “sexy end” of the business intelligence suite of tools, but it’s absolutely essential. Liked our content? Want more? Take a look at guides and tutorials on Excel, Microsoft Office, and Windows below.Whatever you prefer to call it (we’ll call it Power Query in this article), this software allows you to connect to data from a variety of sources (eg, Excel files, internet data, SAP business warehouses, Access files, and other databases), then manipulate it, say, by removing unnecessary data, additional spaces, and unpivoting elements, and finally load the tailored version of the combined files in such a way they may be used by Excel (eg, Power Pivot) for further analysis.

This is how you can convert rows to columns and columns to rows in Microsoft Excel. Your row will now be transferred to a column or your column will now be transferred to a row. At the bottom, you will see an option to transpose, check that box, and select OK. Right-click on the cell and then choose Paste Special from the menu. Now select the cells on your spreadsheet where you want your first row or column to begin.

Right-click on the selected rows or columns to bring the drop-down menu, choose Copy to copy the contents of the cells of rows or columns in Excel. Microsoft Excel has a transpose feature that enables the user to move your row data into columns or the other way around, just select the cell by highlighting the rows that you want to transpose into columns or columns that you want to transpose into rows. How to convert rows to columns or columns to rows Try this workaround that would allow you to simply move the data from the rows to columns with a couple of steps.

Ever wanted to convert rows to columns or columns to rows in Microsoft Excel? When you have a number of rows filled with data in your spreadsheet and you want to convert or transform those rows into columns, then adding it manually one by one would take a lot of time.

Transform columns to rows in excel