Pivoting data without an aggregation column

Don’t use PIVOT for non-aggregate-able data I ran into a rather displeasurable experience where a separate team of people built some very important tools for us and they did a lackluster job and...