I have a table to data, basically, I check monthly returns from various departments, and i want to be able to produce a table that will display on a given the month the recertification dates (AA-AD) or if nothing is present remain blank per domain. I have highlighted in red the heading i want to include.
I thought a pivot table would do this but I cant get it to display dates.
I've attached an example which hopefully explains a little better.
Thank you for your help example10.xlsx