Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1715-1716.xlsx
Learn how convert a column of records into a proper data set with an Excel Worksheet Formula.
Topics:
1. (00:00) Introduction to two methods.
2. (00:46) Microsoft 365 Excel Formula: INDEX, SEQUENCE and ROWS functions.
3. (02:32) Formula that works in any version: INDEX, COLUMNS and ROWS functions.
4. (04:23) Summary, Closing and Video Links

ExcelIsFunTue, August 10, 2021 3:08am