Help Involving Crosstab

[Ryan86]

I posted a thread already, and am reposting thinking that running a crosstab query will be the first step of what I am trying to accomplish. For more backstory see my previous thread here. In the attached picture I have run a crosstab query that shows store numbers in the Rows, and item numbers across the columns. Each row shows (via a 1 indicator) which items are stocked in that store. What I then need to accomplish is to know how many stores share the exact same combination of items. Essentially each specific combination of items could get a unique indicator. In the provided example it would be 3 different combinations, shown highlighted in different colors. Its almost like I need to find out how many rows are entirely duplicated (exluding the store number). The reason for needing to know this, is for work planning each store that has a different combination of items will ultimately require a different store layout plan for where the product goes, so this way we can determine how many individual store plans will need to be created.

[aytee111]

You need a math wizard! Something like adding up all the item numbers, maybe adding an odd number to each item number (like 361) to avoid duplicates.