I believe I finally figured it out after hours of trial and error. In a previous post from ChrisM he said "lets add a row number" and that made...

Here's the situation with the LOB = MNS. MNS has two different properties for the XLOB (ML and MS), for those two different XLOB values there are differing BPL...

Yes, it would be ok to switch values for the values that exist multiple times for the same LOB with different values, but the values that only exist once per...

Yes, that would be ok.

MNS has two XLOC's so it makes it necessary to have both an 'MS' and 'ML' that is what is keeping the 'ML' from being an 'MS' or vice versa.

The uniqueness is across all of the attributes as a set. So in the example, there is a unique combination for MNS across XLOC, BPL, CRE, and ARA. ...

sorry about missing the 'COM' I edited the previous post and added it in.

As for the "comes in looking like this", this is not an import. It was how...

Can we push the reset button? I think I derailed people by mistake. Here's a smaller set of data and a before and after of the result set....

Option 1 is what I am looking for.

I would like to just apologize right now for describing this poorly. I do appreciate whatever assistance you can provide. 🙂

For a business requirement, I am trying to satisfy a need for each LOB to be listed with distinct rows for each unique attribute and it's unique value with the...

Jacob, due to J Livingston's data set, there would need to be 4 rows for each distinct LOB/XLOC/CRE combination. In the example i provided earlier the MNS had two...

I can't change the table design as too many production systems would be impacted.

As for what I would expect for a result...here's what I would hope to see

LOB...

ChrisM, I was looking at your response/solution and it looks close, but it's not handing the duplicate records (where there are two instances of MNS with different XLO values)....

Yes, that would be a valid assumption for the LOB/Attribute relationship.

These are the only current fields in the data today, but as additional attributes are added it would need to...