mat2piv.m

Flatten an N-dimensional tensor into an Excel pivottable ready form

Takes an N-dimensional vector/matrix/tensor M and optional user-provided labels and flattens it into a cell array suitable for use as an Excel pivot table datasource. The resultant 2-dimensional cell array P will be a matrix with one row per element in M and N+1 columns: one column to hold each dimension's labels plus one to hold the values. This cell array P is suitable for export to Excel to be used as a data source for a pivot table.