Delete rows depending on number of columns

[gildartzz]

Hi, I would like to know how one can delete multiple rows depending on the number of columns that they have.
For eg. say I have 100 rows and the number of columns with data are different for each row. Now I only want rows that have exactly 10 columns with data and delete the ones that dont meet this requirement.

 

[gildartzz]

Another way to do this would be using filter but I haven't tried that. Might be faster.

On my PC it took about 15 seconds to run with 2000 rows.

ohh cool. Will try running it again

 

[gildartzz]

thanks kweaver , it worked this time.