Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1765.xlsx
Learn how to convert a horizontal range of labels to a vertical numbered list of labels. Learn how to do it with a formula in Microsoft 365 Excel and an “Old School” method that will work in any version of Excel.
1. (00:00) Introduction
2. (00:20) Dynamic Spilled Array Formula that works in Microsoft 365 Excel
3. (00:45) SEQUENCE Function
4. (01:23) Join Operator (Ampersand &)
5. (01:40) TRANSPOSE Function
6. (01:55) Formula that works in any version of Excel.
7. (02:01) ROWS function with an expandable range
8. (03:13) INDEX Function
9. (04:10) Bonus Formula: ROW function!?!?!?!
10. (05:03) Closing and Video Links

ExcelIsFunTue, November 23, 2021 7:46am