3 Easy Ways to Flip Data in Excel (Reverse the Order in Columns / Rows)
How to flip columns in Excel using the SORT tool
Here are the steps for using Excel’s SORT tool to flip columns:
1. Assemble all your data into a table
You can start by compiling all of your information into a table. If your data is already in cells, you can select every one of them and choose “Insert Table” from the “Insert” tab’s options. Add row headers if you didnt already. The table may look something like the example below:
2. Insert a new “Helper” row
Right-clicking anywhere on your current table will reveal a menu of options. Navigate to the “Insert” drop-down menu. Choose the choice that enables you to add a new row. The column could be positioned above the “Number of Absences in 2021” row. You can either leave it where it is or move it so that the bottom row of your table is where it should be. Name the new row “Helper. “.
3. Select the entire table and open the “Sort” pop-up window
By selecting the upper-leftmost cell, holding down the mouse button, and dragging it to the bottom-right cell, you can select the entire table. Click the “Data” tab in the Excel ribbon after selecting the entire table, including the “Helper” row. Over the “Sort & Filter” section, select the “Sort” button.
4. Choose the appropriate settings within the “Sort” pop-up window
Clicking the “Options” button in the “Sort” pop-up window will bring up another dialog box. Select “Sort left to right” from the menu, then click “OK.” ” This returns you to the original “Sort” pop-up window. Here, you can choose “Helper” for the “Sort by” selection. You can also change the “Order” to “Largest to Smallest. ” Click “OK” to see the table flip its columns.
What does it mean to flip columns in Excel?
Excel’s “flip columns” feature allows you to reverse the order of the data in your cells. When a team member enters data in a different order than how you want to view it, it can be useful. Using Excel’s tools to flip columns can eliminate the need for manual adjustments and save a ton of time.
How to flip data horizontally in Excel using the SORT tool
Here are the steps for using Excel’s SORT tool to flip data horizontally:
1. Organize all your data into a table
Creating a table with all of your data organized is the first step. Click on the “Insert” tab in the Excel ribbon after selecting every cell you want to turn into a table. Choose the “Table” icon. You can add headers to the table if none already exist. Your table may look something like the example below:
Matthew Johnson $7,124; Charles McCoy $8,596; Kevin Milsap $4,367; Travis Taylor $5,512; Timothy Moore $3,674; Tina Wilson $10,777; Donald Allen $9,544### 2 Insert a new column and give it the title “Header”.
Click on any cell in your new table. Open the “Insert” menu by clicking with the right mouse button. Select “Insert Columns to the Left” from the menu. This operation results in the addition of a new column to your table. Change this columns title to “Helper. The column’s position is irrelevant, but you can make it the rightmost column in your table to make it easier to read.
3. Fill your column with a series of numbers, starting with one
When you first insert it, the “Helper” column is empty; however, you can fill it with a series of numbers, beginning with one. You may enter these numbers manually. It might not be practical to manually enter the numbers if your data set is very large.
Instead, you can speed up the process by using the “Fill Handle” tool. Fill out the first “Helper” cell with “1,” and the second “Helper” cell with “2.” Highlight both cells so they turn green. Select all of the cells in the “Helper” column by dragging the small green box in the bottom right corner. This fills all the cells with numbers in ascending order.
Matthew Johnson $7,1241, Charles McCoy $8,5962, Kevin Milsap $7,4543, Travis Taylor $4,3674, Roman Wallace $5,5125, Timothy Moore $3,6746, Tina Wilson $10,7777, Donald Allen $9,5448, etc. Name**Sales in January**Helper### 4 Select the entire table.
By selecting the upper-leftmost cell and dragging your cursor to the bottom-rightmost cell, you can select all the data in your table. Make sure all the headers are selected, such as “Name” and “Sales in January” in the example above. Additionally, you can verify that you have chosen the entire “Helper” column.
5. Navigate to the “Sort” tool and choose the appropriate settings
After selecting all of your data, go to the “Data” tab on the Excel ribbon. Click on it and find the “Sort & Filter” section. Click on the “Sort” icon. This causes the “Sort” pop-up window to appear. Select “Helper” from the drop-down menu under “Column” by clicking on it. ” Leave the “Sort On” column as it is. Change the “order” setting to “Largest to Smallest” from “Smallest to Largest” ” Click “OK” to see the data reverse its order. To make your table simpler to read, you can remove the “Helper” column.
How to flip columns in Excel using the SORTBY function
If you’d rather flip columns in Excel using a formula, here’s how to do it with the SORTBY function:
1. Organize your data into a table
Creating a table with all of your data organized is the first step. Knowing the cell names is a requirement for this method, so use the example below as a guide. Wherever you want to place the new table, copy the header names. Consider placing the “Store name” and “Number of employees,” for instance, in cells C1 and D1, respectively.
AB1Store name**Number of employees**2Octane183UpNorth294Tierra145BlackStar22### 2. Begin typing the formula into cell C2.
Locate cell C2. This is the leftmost cell of your new table. Enter an equal sign before typing SORTBY to start entering the formula. Create an open parenthesis so you can insert the additional information.
3. Type the remaining elements of the formula
Define the entire range of the data in your original table after the open parenthesis. In the above example, the range is A2:B5. On your keyboard, press “F4” to make the data range absolute. Type a comma and then type the word ROW. Type the range A2:B5 inside an open parenthesis without making it absolute. To make the data appear in descending order, type a closing parenthesis, a comma, and the value -1. Insert a final closing parenthesis and hit the enter key. By doing this, a new table is created with the data arranged in reverse.
Please note that Indeed is not affiliated with any of the businesses mentioned in this article.
FAQ
How do you flip two columns in Excel?
Hold the Shift key while performing a left click on the column’s edge. Move the column to the other one by dragging it there. The following column should be indicated by a line beginning with the symbol “|” Release the mouse and the Shift key.
Can you reverse order of columns in Excel?
- Copy the cell range.
- Choose the blank cells that you want to paste the reversed data into.
- Select Paste Transpose by clicking the Paste icon on the Home tab.
How do I flip columns from left to right in Excel?
- Copy the cell range.
- Choose the blank cells that you want to paste the reversed data into.
- Select Paste Transpose by clicking the Paste icon on the Home tab.
How do you flip all columns and rows in Excel?
- Copy the cell range.
- Choose the blank cells that you want to paste the reversed data into.
- Select Paste Transpose by clicking the Paste icon on the Home tab.
