Primary Location and Other Location - multiple rows
We have a Primary Location on a requisition and have captured a 'Other Location', after selecting these two columns in my report, the Primary location is correct, but the 'Other Location' is showing multiple rows for primary location and the actual location that was captured. I am using the 'Requisition Primary Location' - 'Work Location Name' this is displaying the correct data. For 'Other Location' I am using 'Requisition Work Location' - 'Work Location Name' this is returning two rows, it looks like the primary location and the other location.
Please advise which columns, from which folder, I should be using to get the primary location and other location for a Requisition.