Hi all,

I am working on the master file for the marketing team in my company. From the information in table 1 (which is currently showing by programs), I would like to show what programs do we have for each week (table 2, which I did manually) by using formula. I attached the file for your reference.

Thanks everyone!