The Collapsed Text Method employs the `TEXTJOIN` function to collapse multiple values from a dynamic array into a single text string for display in a table.

Microsoft is making some improvements to how formulas work in Excel, with a new feature called Dynamic Arrays that allows formulas to output values to more than one cell at a time.

Excel already lets you target columns in tables fairly easily, but working with arrays hasn’t been as easy and now that any formula that returns multiple results spills them into a dynamic array ...

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

You can combine text from multiple cells into one cell in Excel using the Ampersand symbol (&) or by using the CONCATENATE function.