mat2piv.m

版本 1.0.0.0 (6.4 KB) 作者: dan
Flatten an N-dimensional tensor into an Excel pivottable ready form
467.0 次下载
更新时间 2014/8/5

查看许可证

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.

引用格式

dan (2024). mat2piv.m (https://www.mathworks.com/matlabcentral/fileexchange/47446-mat2piv-m), MATLAB Central File Exchange. 检索来源 .

MATLAB 版本兼容性
创建方式 R2014a
兼容任何版本
平台兼容性
Windows macOS Linux
类别
Help CenterMATLAB Answers 中查找有关 Tables 的更多信息
致谢

参考作品: Pivot/unPivot, pivottable

启发作品: mjeppesen/matlab-pivot-table

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
版本 已发布 发行说明
1.0.0.0