An Amazing Alternative to PivotTables for Displaying Text Values in Excel

An Amazing Alternative to PivotTables for Displaying Text Values in Excel | Excel University

If you are trying to use a PivotTable to display text values in excel, check out this advanced excel tutorial video which demonstrates an alternative. Instead of using a PivotTable, it illustrates how to use Excel formulas and the FILTER, UNIQUE, SORT, TRANSPOSE, and ARRAYTOTEXT functions.