I have a list (Structural Column in this case) where the Column Location Mark is made out of a structure X - Y.
I’m trying to extract X (anything before the -) and Y (anything after the -) to a single list and then just keep the unique values.
I figure i can use List.UniqueItems once i deconstructed the initial list to get the Unique Values