12-04-2020 06:02 AM
12-04-2020 06:36 AM
@Zan_Hanifee Here's a quick-and-dirty way to do it.
Add a helper columns and enter this formula on the first row
Copy it down as far as needed and put a filter of the table. Filter the helper column to show only items 2 and 3. Copy and past all to a new table.
12-04-2020 07:13 AM
I think I found a solution for you, as long as the pattern remains keep 2, delete 3.
Highlight the pattern and drag it down the list to populate every 2 rows with keep followed by 3 rows with delete:
I also created a video for this if that makes it easier to understand: https://youtu.be/_sLbzkN4veg
I hope this resolved your question!