>>
>>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
>
When I tried it with real data, I got something like this
>
>Sunday Monday
>Loc1 Loc3
>Loc2 Loc4
>Loc5
>Loc6 Loc7
>
On second thought- or third or fourth thought..that blank cell might be OK
I'll look again
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.