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.
Question.. so I am putting together multiple sheets, but the problem is I need the first 13 rows of each sheet to be deleted. I know if I use the Sample tool I can get rid of the first 13 rows, but that only does it for the first sheet added. I need it to do it for all of them. Any ideas?
How are you breaking the data into separate sheets? Please provide a sample if possible. If it is a specific identifier that separates the sheets you could use a Multi-Row Formula tool to add a new column that restarts each time it finds the identifier, then use a filter tool to remove the lines (see attached workflow that filters on the first line).
FYI - Usually these questions are put in Designer Discussions as more people look at that thread.