One Word: Pivot.

More Words: A down side of using Pivot is that you have to specify the values to pivot from row values into column names. However, the example...