Sorry the earlier output expected didn't formatted properly so i have split it into two halves ( by seperating columns)

First Half of the result

Date Location ...

Thanks for the responses and sorry for not posting appropriately.

The final results should be in graph with 5 series on the y axis count of visits and on x axis...