Forum Discussion
Excel
Dec 04, 2020Iron Contributor
delete 3 rows after every 2 rows
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 -
Riny_van_Eekelen
Dec 04, 2020Platinum Contributor
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.