Step 2: Copy the selected cells either by right-clicking the selection or choosing Copy from the context menu or by pressing Ctrl + C. To quickly select the whole table, i.e., all the cells with data in a spreadsheet, press Ctrl + Home and then Ctrl + Shift + End. Step 1: Select the original data of your table. To switch rows to columns, you need to follow the following steps, such as: The country names are organized in columns, but the list of countries is too long, so we did better change columns to rows for the table to fit within the screen: Suppose you have a dataset similar to shown below. Convert Rows to Columns in Excel using Paste These solutions work in all versions of Excel 2016, 2013, 2010, 2007, and lower. Microsoft must have anticipated this issue because they offer several methods to switch your columns and rows around. You often build a complex table to realize that it makes perfect sense to rotate it for better analysis or presentation of data in graphs. Transposing data in Excel is a task familiar to many users.

With it, you can quickly switch data from columns to rows, or vice versa. If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. There’s a really easy fix in the Paste Special menu that allows you to reverse your mistakes and columns to rows without starting over.

With Excel, the option of copy/paste the entries into the other place or start over would be wrong because it can paste all entries into the same row or same column. Sometimes these preferences lead to a scenario where you want to transpose Excel data. Others prefer the data vertically in columns. Some people create Excel spreadsheets with the main fields horizontal. After incorrectly entering data, one of the most common mistakes is transposing columns and rows. You store your information or data in various rows and columns.

Change column into row excel