Hi,

I am importing an Excel spreadsheet from another system into DataPrep.

Unfortunately, that system exports the spreadsheet with 2 rows above the row that contains the column names. It also adds some rows to the bottom of the data set, with some totals.

I need to remove those 2 top rows and also the bottom rows that contain the totals.

Is there a way to do this automatically after importing the spreadsheet into DataPrep?

Thank you in advance.

Tiago.