If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...
Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.
How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...