Delete excel rows based on a pattern(1line with value and the following 2 lines with empty cell, repeat)
Budget: $80 – $240 HKD
I have a csv file which contain around 100k rows of content.
1) Column A to J should have contents on everycell on all rows
2) Column K to S should have contents on a pattern which is the 1st row have contents on everycell, the 2nd and 3rd row should have empty cell, then repeat on the 4th to 6th row, repeat til the end of all data.
However, the data is not that clean as the above mentioned.
What I want to achieve is:
for 1) Column A to J, if there are missing value on one of the cell, delete the whole row,
for 2) Column K to S, if there are missing value on one of the cell, delete the whole row. If the pattern is not the same as mentioned above, delete the next row or next 2 rows until the pattern matched with the pattern mentioned above(1row with value, the next 2rows with empty cell, repeat)
1) Column A to J should have contents on everycell on all rows
2) Column K to S should have contents on a pattern which is the 1st row have contents on everycell, the 2nd and 3rd row should have empty cell, then repeat on the 4th to 6th row, repeat til the end of all data.
However, the data is not that clean as the above mentioned.
What I want to achieve is:
for 1) Column A to J, if there are missing value on one of the cell, delete the whole row,
for 2) Column K to S, if there are missing value on one of the cell, delete the whole row. If the pattern is not the same as mentioned above, delete the next row or next 2 rows until the pattern matched with the pattern mentioned above(1row with value, the next 2rows with empty cell, repeat)