Duplicate Rows

[#1]

I have a table in in JMP 16.0 that has duplicate rows with respect to one of the columns.  I would like to retain the first row and delete all the following rows. For example from Table 1 to Table 2.

Table 1

timothy_forsyth_0-1707763090894.png

Table 2

timothy_forsyth_1-1707763154841.png

[#2 · Accepted solution]

There are many options of doing this. One which might work in this case is to use Select Duplicate Rows

jthi_0-1707764301112.png

Select your column you wish to use for "unique" selection and go to that selection, select rows and delete extra rows