How to delete Rows 1 and 3

bubblyjai1982

Hi All

I have set of data where I want to remove row number 1 and 3 completely

Tried using "Sample Tool" to removed only two rows but this is not giving correct result instead its extracting a specified portion of the rows in data stream.

please find the attachment - only row 1 and 3 want to delete completely

Many Thanks

How to delete rows.xlsx

Workflow

Accepted answers

OTrieger

@bubblyjai1982
There are several ways how to do it.
I would start the data from row 4 and then the line 3 will be the header. And I would replace the headers. The good thing in this method that you will get the correct data type for the fields.

Another way get the data from Row 2, so first line of data will be Row 3, Then you can filter the data based on field content and row 3, which will row 1 will be removed. In this case all your data will have string data type

binu_acs

@bubblyjai1982

Exclude_rows_14022025.yxzp

All comments

OTrieger

binu_acs

@bubblyjai1982

Exclude_rows_14022025.yxzp

bubblyjai1982

Thanks OTrieger and Binuacs

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703