August 20, 2022
I'm using the following Lambda function I found online to un-pivot a table where the first column of data are dates. I would like to do this using a formula and not power query. The Lambda function seems to convert the dates to text uses textjoin & textsplit functions.
How do I modify the formula such that the array spills the first column in date format as it was originally?
How do I make the resulting un-pivoted array into a table so that I can use pivot tables?
I have included a sample file and the Lambda formula is as follows:
November 1, 2018
Dynamic array formulas do not work in tables, though you don't really need a table to use normal pivot tables.
You could simply amend your output formula to use something like: