I have two lists, one is Room Name, and one is Occupancy Load Factor. I need to create a list that reads all of the room names and all of the Occupancy Load Factor, and show only the unique values between the two lists. One office may have a 150 OLF, another office (Same name) may have a 50 OLF. So I need to create a list that has all unique names, and all (Matching) unique OLF values to the unique name.
I’m absolutely losing my mind trying to pair the list. Any help on this would be massively appreciated!