Google Sheets: SORT, INDEX, ROWS
My favourite Killjoy members. Column A – From most favourite. Column B Saving the best for last.
Sometimes you have a need to reverse a list quickly in Google Sheets.
That’s pretty easy to do if the list is sorted alphabetically. Just go on into the <Data> menu and choose from one of the
sort functions. But what if the data you want to flip is not in alphabetical or numeric order?
Below are 3 ways to reverse your data:
Also check out the last example on
how to flip a column in Google Sheets.
For the examples below, I’ll be using a list of my favourite
Killjoys characters. Yeah, I’m a sci-fi geek.
Continue reading “How do I reverse a range by Rows or Columns in Google Sheets”
Have you ever wanted to split a list of Google Sheet rows in two by odd or even? Or had a time when you wanted to display all items in a range by odd or even ids in two separate lists?
You don’t have to do this manually, we can work smart and create a formula for each of these scenarios to easily separate your data.
In this tutorial, we will cover three scenarios:
Separate a range of data by odd and even rows.
Separate a range by odd and even where a selected column has a list of numerical ids.
Separate a range by odd and even where a selected column contains a list of alphanumeric ids.
If you want to play along, you can get a copy of the starter sheet here:
Odd and Even | Starter Google Sheet*
*Contains Easter Eggs.
Continue reading “Displaying Odd and Even Row Data in Google Sheets”