Manually PIVOTing usually comes down to a combination of an aggregate function (SUM, MAX etc) around a CASE statement, coupled with a GROUPing. It's a bit more advanced to figure out but can be significantly more efficient in cases where your need to pivot based on multiple columns.