I'm working on rolling-up a series of charts. I'd like an easy way to summarize by category. The original looks like the sample below but by week for the entire year.

I want to know all of the AD 1's, etc. I will need in CA (for each state) by Publication.

so the end result would be CA AD 1 PUBLICATION 1

CA AD 2 PUBLICATION 1

CA AD 3 PUBLICATION 1 PUBLICATION 2 PUBLICATION 3

A B C D E 1 PUBLICATION1 CA TX NM AZ
2 AD 1 ·
3 AD 2 · · · ·
4 AD 3 · · ·
5 PUBLICATION2 CA TX NM AZ
6 AD 1
7 AD 2 · · ·
8 AD 3 · · ·
9 PUBLICATION3 CA TX NM AZ
10 AD 1
11 AD 2 · · ·
12 AD 3 · · ·

Thanks so much!