Download Excel File: https://excelisfun.net/files/EMT1788-1789.xlsx
Learn how to convert frequency distribution into original column of data using the functions: SEQUENCE, IF and TOCOL. Lean about array operations of arrays with different dimensions.
Topics:
1. (00:00) Introduction
2. (00:28) Formula to convert frequency distribution into original column of data. See the functions SEQUENCE, MAX, IF, and TOCOL.
3. (02:56) Old Scholl way with Power Query
4. (03:13) Summary, Closing, Video Links