Forum Discussion
Data Formatting
An alternative could be Power Query which works in Excel versions starting from Excel 2010. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Thanks a lot PeterBartholomew1 for providing the sample data in an Excel file and for the 365 solution.
Thank you PeterBartholomew1 , sorry to not mentioned earlier that the criteria to choose should be a combination of hfnTickCount-sfn-slot , rather than sfn only as after a cycle sfn and slot will be repeated but the combination of these 3 will be unique
Also, could you please help share the link to that Github you mentioned , any Tutorial to get through these creation of customized "lambdas".
It's really interesting for me to know that excel does't know that "UNPIVOT.CSVλ", still how come it executed that.. Good to know that too..Thanks!
Thanks in Advance,
Br,
Anupam
UNPIVOT.CSVλ is simply a defined name I used to reference the Lambda function. The MAPλ helper function is posted on my GitHub repository
https://gist.github.com/pbartxl/a14b250985da31be843ce9ff35d888fc
What it does is to allow the in-built MAP function to return arrays of arrays (without introducing additional lambda functions to reference the inner arrays you would be limited to arrays of scalars which is not that much use)!
Since I found myself implementing unpivot functionality it would probably have made sense to consider a more overt database strategy! 😆