Editing rows in a large data table

[#1]

I have a large data table and want to delete every other row. Is there a way to do this with one command or does one have to go through the table manually removing every other line? I attach a sample of the table and I wish to remove all the lines with 3651 under 'final' and 'max'.

[#2]

I assume both of your columns are character columns, you can select both of those columns, right click on column header and create new formula column with concatenate

Then select one of those rows which has "3651 3651", right click, select matching cells and finally delete rows

[#3]

Thanks for your help. Very useful and just what I needed.

[#4]

The approach that I would use is similar to Jarmo's, however it does not require the creation of a new column.

1. In row 1 for the column named [final], click on it's cell that has the value 3651.  The cell will then be highlighted
2. In the same row, go to the Column named [max], hold down the CNTL key and click on the cell.
3. Both cells will then be highlighted(selected)
4. Move the pointer(mouse) the rowstate column for row 1, which will also be highlighted(selected)
5. Right click on that cell and choose "Select Matching Cells".  All rows that have values of 3651 in columns [final] and [max] will be selected.
6. Right click once again in the rowstate column for one of the selected rows, and choose, " Delete Rows"