Uploading Data from Excel File into SAP using t-code SCAT

Hi Experts,

We have SAP script for order upload, which runs into number of columns with reference to materials to be inserted into the line item.

Here is given an excel file with the data into the landscape format. Requirement is to delete some of the columns of that file before uploading to SCAT. But the problem is, if we want to delete the certain column (like Unit Price); we need to deliberately delete column by column.

It has been suggested that if we turn the excel file in portrait before uploading would lead to solution, as it would be easier to delete rows.

I would appreciate if any other solution can be given to eliminate required number of columns before doing upload from the excel file.

Regards,

Kunal.