Delete Top and Bottom Rows from Excel

Delete Top and Bottom Rows from Excel

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.


      • Sticky Posts

      • How to Add Users to your Organization in ZohoMail?

        A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________