Yes, that entry was intentional as well as the other duplication in the results.

ChrisM/ER...Here is the full dataset i am working with and then below that is the what i need the data to look like after it is pivoted.

CREATE TABLE...

ChrisM...in your solution, if there were additional possible values in the Attribute column, would you need to have an OUTER APPLY for each of the possible attribute values?

ER...I am hesitant to mark that as a solution only because I don't believe it solves the issue if there are more than one duplicate. I am hoping to...

I would recommend using the Excel Task from CozyRoc. With that component you can specify a worksheet and column and and it will return the value that can be...