Thanks Matt. I like it.

I think I had been more focused on removing A from the row labels/column labels list in a pivot table, which this solution won't do, but displaying a zero next to A in the values section should be a good workaround.

If I revisit this in a few days and figure out how to remove A altogether I'll post a reply.