Pivot Table possibility
 

I have data that is set up in a list...that includes region, store
name, store number, store address, store city, store state, and store
zip. I want to pivot each region (page by field I am assuming) and
have all the data fall into a list that just shows me each stores
name, number, address, city, state, and zip. I can only get it to
give me a count function and I just want a list any suggestions?

Brandon