If a cell contains a Symbol, then paste a Description into another cell
- by Lola
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!