WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 178

Аватар автора
Работа с базами данных Excel
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?

0/0


0/0

0/0

0/0