Hi,

I am looking for an alternative to Pivot table.

I have 2 columns of text data, 1 with the labels and other a subset. Something like this-

Employee Day
A Mon
B Tue
A Wed
B Thu

I would like to know if there is an alternative to pivot tables so I can use named ranges that change dynamically.

Thanks in advance.