With the introduction of Dynamic Arrays in all versions of Microsoft 365 (formerly Office 365) it is now a lot easier to use the TRANSPOSE function.
Tag Archives: Dynamic Arrays
New Formula Symbol in Excel
The @ is re-purposed and the # is new
With introduction of Dynamic Arrays in Office 365 Excel has one new formula symbol and another that was previously only use in formatted tables.
New Dynamic Array Function SEQUENCE
Part One - its all about spilling
Dynamic arrays have the potential to change the way Excel spreadsheets are created. They were released in the January 2020 wave of updates to the Office 365 subscription version.