https://www.excel-easy.com/examples/dynamic-arrays.html
Dynamic Arrays in Excel (Easy Steps)
Dynamic array formulas, entered into a single cell, fill multiple cells. This behavior in Excel 365/2021 is called spilling.
arrays in exceleasy stepsdynamic