Forum Discussion
Matrix with Three Axes
If all you require is to collect data then a common practice is simply to repeat the block of data.
The spreadsheet is probably better than any other software for representing such data.
It gets complicated if you want to perform calculations based upon data held in such formats. The methods I showed were aimed at supporting such calculation and demonstrated new functionality emerging within Excel 365.
The other strategy for storing data is to place it within a single column and then add fields to describe the remaining attributes. Such database tables form a good basis for subsequent calculation.
Is their a video out there that explains how to use the lambda function for a 3d array?
I did describe how a 4D array might arise and show the use of some lambda functions to reference elements of such an array, as well as transforming the array and summing by row or column. I used matrix multiplication to perform the summations but that is out of date now as new helper functions have appeared in Excel.
Announcing LAMBDA (microsoft.com)
https://www.youtube.com/watch?v=r4DD9PeVtmA
Announcing LAMBDA Helper Functions (microsoft.com)
An alternative to holding data as an array, it is also possible to use a data table with attributes representing the indices each in its own field. The data tends to be manipulated with Pivot tables or PowerQuery.
Pretty much any scripting or programming language will also handle arrays, The best one tends to be the one you know!