Filtering out duplicate requisitions in a Talent Tracking Report

Summary

Looking to filter out duplicates when multiple locations are tied to one requisition #, also when including collaborators, it lists duplicates to include every collaborator vertically.

Content

Looking to find a way to filter out duplicates from a talent tracking report of open positions. I want the primary or first location to show and then if possible the collaborators to be listed horizontally, and if not then just the first collaborator. See example below. I am very new to OBI reporting so if it takes some code somewhere specific under a specific field I am hoping for some step by step instructions.