• I am not sure if I can create a simpler example than this...

    Happy holidays!

    I am having issues using PIVOT. I have never seemed to truly understand the syntax behind it and I know this is a simple question....

    I have a simple table that has 3 columns: DayofWeek (Mon - Fri), Time(8:00AM - 5:00PM for each day), and CallsOffered (This is the aggregate). I just need to pivot on the DayofWeek, so I can have Mon - Friday as column names and I cannot seem to do it correctly.

    Any help would be greatly appreciated!