Basically one record is an input by each user. I need to be able to display the data with up to 6 different groupings in one row. I will attach an image to display. There could be up to 6 different 'Names' which I call Users. In the example below there are only 5, so the 6th should be blank in those columns. I've been unsuccessful at trying to append, union, cross tab, you name it.
I should know this but I've been trying for too long and its just not coming to me. Thanks for all you do community!
Current Data
Intended format
