I'd use what Jacob suggested. This an easy way to move rows to columns when they are aggregated based on some value in the rows.