Tag: DROP

DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row.

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1788-1789.xlsx
Learn how to create a formula Frequency Distribution Report with Total Row and learn how the DROP and TAKE Array Functions can be helpful in dynamic spilled array formula reports..
Topics:
1. (00:00) Introduction
2. (00:20) Continue reading “DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row.” →

TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table.

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1784-1785.xlsm
Learn how to convert a rectangle of data with row headers and columns headers into a proper table of data using Array Functions such as DROP, EXPAND, TOCOL and INDEX.
Topics:
1. (00:00) Introduction
2. (00:30) Continue reading “TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table.” →