Excel's Expand Function

Online course: Excel 365 for Busy People
www.udemy.com/...
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTrainin...
Between the Sheets, Episode 30: Excel's Expand Function
Excel’s new Expand function will expand the size of an array by the number of rows and columns you specify. It can also load text or numbers in the expanded cells. Note: at the time of this recording, the function was still in beta. It has since been released and is part of Microsoft 365.