How do I delete a summary row and all information after the summary row

[mc_ryan]

My excel spreadsheet has header and footers. I started the data import on line 4, but how do I stop it at the summary row and everything after?

[Luke_C · Accepted solution]

Hi @mc_ryan 

Use a filter tool on one of the fields with the 'Is Not Empty' option. 

[mc_ryan]

You're a genius! It worked again, thank you so much!

[Luke_C]

@mc_ryan Great! Happy to help