I am trying to do a pivot table but I have repeated info in two columns that are related so I cannot use the remove duplicates. What can I do?

[pinkybabs]

I have the following table and I cannot remove duplicates from as I have different routes with the same number , so, numbers repeat in different columns.
I will try to explain better:
I want to remove the duplicate numbers in the column stop id but only if they are from the same route.
example on the photos attached
I only want 1 stop id for route 104 but I want to keep stop id 11 for route 114
How can I do this????
I am going insane trying to figure this out.
Thank you in advance for any help

 

[pinkybabs]

I have the following table and I cannot remove duplicates from as I have different routes with the same number , so, numbers repeat in different columns.
I will try to explain better:
I want to remove the duplicate numbers in the column stop id but only if they are from the same route.
example on the photos attached
I only want 1 stop id for route 104 but I want to keep stop id 11 for route 114
How can I do this????
I am going insane trying to figure this out.
Thank you in advance for any help

I should have said this is pivot table