So yeah, this how you can switch table rows with columns. With merged cell output may not be correct or may produce an error. Precaution: Before turning rows into columns make sure that you don’t have merged cells. Whenever you change data in the original data, it will be reflected in the transposed table too. Note: This transposed table is linked with the original table. Rows data is now in columns and vice versa.

Hit CTRL+SHIFT+ENTER to enter as multi-cell array formula. Since you selected the range, start writing this formula: To transpose we need to select 3x11 table. In the above example, we have 11x3 table in range A1:C11. It means you have to predetermine how many rows and columns you're gonna need and select that much area on sheet. The TRANSPOSE function is a multi-cell array formula. If you want dynamic switching of rows and columns in excel with an existing table. It brings us to the next method.Ĭonvert rows to columns in excel using the TRANSPOSE function For dynamic switching of columns with rows use excel TRANSPOSE function. Note: Use this when you want it to be done just once. You can also use CTRL+ALT+V to open paste special dialogue.Īt the bottom-right, check the transpose checkbox. Now right-click on the cell where you want to transpose the table. I want to switch rows to columns.Ĭonvert rows to columns in excel using paste specialįirst, select the entire data including headings and footers. Currently, the data is maintained column-wise. Here I have this table of price list of some items on different dates. Let us see by an example, how to convert rows to columns and columns to rows in excel using both methods.

First is the TRANSPOSE function and the second is paste special technique. In that case, excel provides two methods. While working on excel many times you would want to flip table rows and columns.

Excel convert column to row