If the point of PIVOT is to help turn row based values into column based values, how do I use it to produce the same results as the approach using the CASE statements?

I'm just struggling to see the point of PIVOT - the syntax is absolutely horrible and confusing.