# How to Flip Rows in Excel (4 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using excel tools and features. There are many default Excel Functions that we can use to create formulas. Many educational institutions and business companies use excel files to store valuable data. Sometimes, we need to flip the cell values in a row of a dataset to better analyze. We can perform the task very easily using some features and functions in excel. This article will show you 4 simple methods to Flip Rows in Excel.

## 4 Simple Methods to Flip Rows in Excel

MS Excel is a very useful program.  Often, we may have to flip the contents of a row for some reason. It’s easy to do that in excel. To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset represents Salesman, Product, and Net Sales in respective columns. Here, we’ll rearrange the order of the columns. That means, we’ll flip the contents of the rows. Therefore, go through the methods below to perform the task.

### 1. Flip Rows in Excel with Paste Transpose Feature

In our first method, we’ll apply the Paste Transpose feature. And we’ll introduce a helper column to get our job done. So, follow the steps below to carry out the operation.

STEPS:

• First, copy the range B4:D7 by pressing the Ctrl and C keys together.
• Then, choose cell B9 to paste it there.
• After that, right-click the mouse.
• In the pop-out context menu, select Paste Transpose.

• Thus, you’ll see the dataset as shown in the following figure.

• Now, we’ll insert a helper column.
• For this reason, input 1,2, and 3 in the range F9:F11.

• Next, select the range B9:F11.
• Afterward, go to Home ➤ Editing ➤ Sort & Filter ➤ Custom Sort.

• As a result, the Sort dialog box will pop out.
• In the Sort by section, choose Column F in Column, Cell Values in Sort On, and Largest to Smallest in Order fields.
• Uncheck the box for My data has headers.
• Press OK.

• Consequently, your data will appear as it’s displayed in the below image.
• Delete the original data.

• Again, copy the range B9:F11.
• Subsequently, click cell B4.
• Apply the Paste Transpose.
• Lastly, delete the helper row.
• Thus, you’ll get the required outcome.
• Look at the following picture where we have our final result.

### 2. Use Excel Sort Feature for Flipping Rows

This time, we’ll use the Sort feature. Hence, learn the following steps.

STEPS:

• Firstly, introduce a helper row in row 8.
• Then, select the range B8:D8.

• Next, click Home ➤ Editing ➤ Sort & Filter ➤ Custom Sort.

• Consequently, the Sort dialog box will appear.
• Uncheck the box for My data has headers.
• Press Options.

• Click the circle to Sort left to right.
• Press OK.

• Subsequently, choose Row 8 in Row, Cell Values in Sort On, and Largest to Smallest in Order fields.
• Press OK.

• Finally, it’ll return the desired output.

### 3. Apply VBA to Flip Rows in Excel

Moreover, we can apply excel VBA for flipping rows. Now, follow the below process to use VBA.

STEPS:

• First of all, go to Developer ➤ Visual Basic.

• As a result, the VBA window will appear.
• Copy the below code and paste it there.
``````Sub FlipRows()
Dim rg As Range
Dim rnge As Range
Dim ar As Variant
Dim i As Integer, j As Integer, k As Integer
On Error Resume Next
xTitleId = "Flip Rows"
Set rnge = Application.Selection
Set rnge = Application.InputBox("Range", xTitleId, rnge.Address, Type:=8)
ar = rnge.Formula
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For i = 1 To UBound(ar, 1)
k = UBound(ar, 2)
For j = 1 To UBound(ar, 2) / 2
xTemp = ar(i, j)
ar(i, j) = ar(i, k)
ar(i, k) = xTemp
k = k - 1
Next
Next
rnge.Formula = ar
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub``````

• Save the file and close the window.
• Now, select Developer ➤ Macros.
• Thus, the Macro dialog box will emerge.
• Select FlipRows.
• Press Run.

• You’ll get another dialog box.
• Select your desired range in the Range.
• At last, press OK.

• In this way, it’ll return the dataset after flipping the rows.

### 4. Flip Rows with Simple Formula

In our last method, we’ll insert the INDEX and COLUMNS functions to flip rows. So, learn the process.

STEPS:

• Select cell B9 at first.
• Then, input the formula:
`=INDEX(\$B4:\$D4, COLUMNS(B4:\$D4))`
• Press Enter.
• Thus, it’ll return the formula output.
• Afterward, use AutoFill to complete the rest.
• In such a way, you can also get the flipped dataset.

NOTE: The COLUMNS function returns the column numbers of B4:D4. The INDEX function retrieves the cell value that’s present in the intersection of COLUMNS(B4:\$D4) outputs in the range \$B4:\$D4.

## Conclusion

Henceforth, you will be able to Flip Rows in Excel following the above-described methods. Keep using them and let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

## Related Articles

#### Aung Shine

My name is Aung. I have my B.Sc. degree in EEE. From now on, I will be working with Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF