Dec 04 2020 06:02 AM
Hello Everyone,
I have a data and trying to delete 3 rows after every 2 rows. How can I do it as deleting them?
Because manually takes too long.
Like -
Dec 04 2020 06:36 AM
@Excel Here's a quick-and-dirty way to do it.
Add a helper columns and enter this formula on the first row
=MOD(ROW(),5)
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.
Dec 04 2020 07:13 AM
Hey @Excel,
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!