Category "dynamic-arrays"

Excel Dynamic Array formula to create a running product of a column

I need to create a running product from a column of numbers (I could use a row, but a column is easier to demonstrate here.) The input might be any arbitrary a

Excel UNIQUE Across Columns

Is it possible for the new function UNIQUE to be used across various columns & have the output spill into a single column? Desired output is UNIQUE values

Excel UDF to Unpivot (Melt, Reverse pivot, Flatten, Normalize) blocks of data within Tables

This question will seek multiple approaches LET/LAMBDA VBA UDF and Power Query Function, so there will be no single right answer, but a solicitation of approach