>
>I tried Naomi's answer. I got blank values in some of the column/row cells and couldn't figure out how to prevent that.
>

I just tried her code (where she used ROW_NUMBER). It works.

One thing...assuming I understand the result sets you're looking for - you *will* have some empty cells, unless for each day you have the same number of locations.

In her brief example with six rows, here's the output. So I guess I don't understand why her query doesn't address it.

Sunday	        Monday
Loc1	        Loc3
Loc2	        Loc4
Loc5	
Loc6