Announcing New Text and Array Functions

It is certainly quite possible to write Lambda functions to pivot datasets.  One I wrote last year uses a challenge article from Bill Jelen but takes it further to use steering data to determine whether the output dimension runs down the sheet, across it or is aggregated.

Re-pivoted, it might look like

It all starts with being able to read multidimensional arrays using the Count, Direction and Stride length elements of the steering data.  Perhaps I ought to publish the workbook.