The data I have: 

```html
   USERNAME |  DATE
   ---------------------
   USER1   |   7-1-2016
   USER1   |   7-5-2016
   USER1   |   7-8-2016
   USER2   |   7-2-2016
   USER2   |   7-5-2016
   USER2   |   7-6-2016
```

I need to select DISCINCT and return something like this:

```html
USER1,7-1-2016,NULL,NULL,NULL,7-5-2016,NULL,NULL,7-8-2016
USER2,NULL,7-2-2016,NULL,NULL,7-5-2016,7-6-2016,NULL,NULL
```

So, to help understand the need for a query like this.
I'd like to output a list of any given week in a more "calendar like" format, where the data is stored in a more linear (one line per date) format.

Thank You.