I am trying to list the elements in a table, but I’m having a problem. I want to only list each Unique Unit Name once. I have a key row that has a double listing and I only want a single list from the double list. I want it to only look like this:
But instead I get this:
I understand it is because I am taking from a table that looks like this:
But I want to know how I could list only one of the two rows that refer to the same Unique Unit Name (I’ve tried .Unique() it didn’t work). It’s like I need .Unique() for existing rows in tables.