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:
*Contains Easter Eggs.