Remove duplicate rows from table

I have a query that shows collaboration between two organizations that i need to display in a table. The problem is that org 1 and org 2 are repeated in the table. For example org 1 is x and org 2 is y but then there's another row where org 1 is y and org 2 is x creating a duplicate in the results. Is there a way I can remove the duplicate values so i only have one pair of org collaboration.

 

ae325586-6ca9-4a79-89ad-7eaa1b4c396d.png
2 0 1,269
0 REPLIES 0
Top Labels in this Space
Top Solution Authors