Hi Rabbit. Thanks for replying. My initial thought was to combine the rows so there would be one record per person and then proceed with the counts of who accessed what service and where. But, I'm trying to see if there is a way to analyse the data from the multiple rows, as a friend thinks that would be more flexible.
For example, we want to create reports showing the number of people who have accessed a certain mix of services (choices include...

H,
I'm hoping some of you can give me ideas on how to deal with our challenge. We are developing a system that will accept excel data files on counseling and health services accessed by users. The users may get the same or different services from multiple agencies in different locations. We want to analyse the combined data to report on the cascade of service accessed and the mobility of users among the locations. This initial phase is meant...