Here's another approach using partioning with cross apply. This also produces the desired result:

declare @t table (

Id int

, Id1 int

, Id2 int

, MasterId int

, Obs char(4)

, Dec...

There are a couple of problems here. First off, PIVOT can only pivot one column (at a time). You could do separate pivots as subqueries for each of...