How do you move duplicate rows in a table?

[rohanmiskin]

I do my search and use the table keyword to get the results and the fields in a table

The table i get is like this

field1|field2|field3|field4
1     |2     |3     |4
1     |2     |3     |4
1     |2     |3     |4
1     |2     |3     |4
5     |6     |7     |8   
5     |6     |7     |8
5     |6     |7     |8
5     |6     |7     |8

The result i want is

field1|field2|field3|field4
1     |2     |3     |4
5     |6     |7     |8

my search query is
mySearchCriteria | table field1,field2,field3,field4

[AKG1_old1 · Accepted solution]

Use dedup:

mySearchCriteria | table field1,field2,field3,field4 | dedup field1,field2,field3,field4