Download Excel File: https://excelisfun.net/files/EMT1784-1785.xlsm
Learn how to pivot a table using the WRAPCOL and SORTBY Array Functions. See SORT, TRANSPOSE and UNIQUE functions also. Convert a table to a cross tabulated table.
Topics:
1. (00:00) Introduction
2. (00:22) Look at the problem with WRAPCOLS if we do not sort.
3. (01:01) Fastest way to solve this is to use a PivotTable or an old school formula with Mixed Cell References.
4. (01:29) Solution with SORT and SORTBY functions.
5. (03:17) Closing and Video Links

Power Query formulas in the Worksheet?