This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to clean up a text-to-columns tool, and I am wondering if there is a way to delete or make null a certain amount of rows. For example, if the row says "DATE:" then make that and the next 5 rows null.
What if I want to get rid of "Deductible State Tax:" and the following N of states? Is there an easier way to do that without having to type out the custom filter for each N of states? Or is there another tool I can use? I tried using the Sample tool but I need all of the rows before and after the state info.
I normally use a method like this that uses a formula to create a new column with the value 1 when the field contains the starting row, a running total on that counter field, and finally a filter when the running total is greater than or equal to 1 so that the rows passed through will be that row onward. Picture is below and screenshot is attached:
Thank you for your prompt response. However, the picture I attached is what I need to get rid of so how would I do that for all the rows pictures in that column for the states? Sorry for the confusion.