Guide To Flip Data In Excel Using SORT And Helper Column

0
154
Guide To Flip Data In Excel

The data in Excel may need to be flipped sometimes i.e. to reverse the order of the data in a vertical dataset or a horizontal data set. Excel does not have an inbuilt feature to do this. Although there are multiple ways to do this using simple sorting tricks, formulas, or VBA. Here is the guide to flip data in excel using the SORT and helper column. This is one of the easiest ways to reverse the order of the dataset in excel.

Procedure To Flip Data Using SORT And Helper Column

Flip Data Vertically (Upside Down)

  • Suppose there is a dataset of names in a column as shown below.Guide To Flip Data In Excel
  • Enter “Helper” as the heading for the column in the adjacent column.Guide To Flip Data In Excel
  • Enter a series of numbers (1,2,3,…) in the helper column.
  • Guide To Flip Data In ExcelSelect the entire dataset (including the helper column).Guide To Flip Data In Excel
  • Click on the data tab.Guide To Flip Data In Excel
  • Then click on the sort icon.
  • Select “Helper” in the sort by option from the dropdown in the sort dialog box.Guide To Flip Data In Excel
  • Select “Largest to Smallest” in the Order dropdown.Guide To Flip Data In Excel
  • Then click OK.Guide To Flip Data In Excel
  • You can delete the helper’s column once done.Guide To Flip Data In Excel

Here only the data of one column is flipped, but this technique can be used for an entire table. Make sure to select the entire table and then flip.

Flip Data Horizontally

  • Make a row with the heading “helper”.Guide To Flip Data In Excel
  • Then add a series of numbers in the row (1,2,3,…).Guide To Flip Data In Excel
  • Select the entire dataset (including the helper row).Guide To Flip Data In Excel
  • Click on the data tab.
  • Then click on the sort icon.Guide To Flip Data In Excel
  • Click on the option buttons in the dialog box.Guide To Flip Data In Excel
  • Select orientation as “Sort left to right”.Guide To Flip Data In Excel
  • Then click OK.Guide To Flip Data In Excel
  • Select Row 3 (Hepler column row) in the sort dropdown.Guide To Flip Data In Excel
  • Then select “Largest to Smallest” in the Order drop-down.Guide To Flip Data In Excel
  • Then click OK.