Forum Discussion
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 -
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.