With your mouse, right-click your new data location. Right-click the new cell and paste your data You can still use the 'CTRL + Z' feature to undo an action. When you use the transpose feature, the copied table replaces any data in the cells you select entirely. Ensure that you have enough room for the data you're copying, as you don't want to overwrite any other data in your table. This can be another cell or group of cells within the same spreadsheet, or you can create an entirely new sheet in the same document. Once you identify what data set you want to transpose to columns, you can find a new location for the data. Related: Basic Excel Formulas and How To Use Them 2. The transpose feature copies all formulas.

You can look for the 'f' symbol at the top of your spreadsheet when you click on a cell, column or row to see if it contains any formulas. Once you highlight your range, verify that any mathematical formulas you want to apply to your data are in place.

It's important to highlight only the information you want to copy, so review the data before you drag your cursor along the entirety of your range. Select the range of data in your current table that you want to transpose to rows. Here are five steps you can follow to convert Excel columns to rows using the transpose feature: 1. Related: How To Add a Target Line in Excel (Using Two Different Methods) How to convert columns to rows in Excel For example, a computer monitor typically orients content horizontally, whereas a phone or tablet might orient the same information in a vertical format. You might apply mathematical formulas to a data set, create a new or duplicate table or format information for a different device. Organizing with rows allows users to add columns as needed, and more horizontal rows to divide those columns into sections. Why convert Excel columns to rows?ĭepending on the size of the data set with which you're working, you might need a specific type of table or to organize the information horizontally in rows to save space. In this article, we show you how to convert Excel columns to rows in five steps, including tips on using rows and columns. Understanding this process can help increase your proficiency with the software. Converting a column to a row can help professionals organize complex data sets or change the orientation of a graph. Excel is a diverse spreadsheet tool with many functions, allowing users to organize information in columns and rows and apply mathematical formulas to data.

Excel row to column conversion