Pivot/unPivot

Version 1.2.0.0 (73,7 ko) par Oleg Komarov
Group a flat dataset into pivot table and unpivot it back
4.3
(3)
1,9K téléchargements
Mise à jour 5 fév. 2010

Afficher la licence

These two functions are meant to format a flat dataset into a pivot table and to unpivot it back.
They imitate the T_SQL pivot/unpivot commands or the pivoting functionalities of the spreadsheet softwares.

If you a have a large set of values which are described by two features (or more) this function allows you to group those values by those two features.

For example, you can sum to the total amount sold over the last 10 months by any of your employees or you can count the number of contracts signed by region and by salesmen and so on...

For detailed help and description see the published M-file or the help of the functions.

For examples see the attached snapshot.

Comments/suggestions/error reports are welcome.

Thanks to Jos (10584) for cell2float.

p4v3

Citation pour cette source

Oleg Komarov (2024). Pivot/unPivot (https://www.mathworks.com/matlabcentral/fileexchange/26119-pivot-unpivot), MATLAB Central File Exchange. Récupéré le .

Compatibilité avec les versions de MATLAB
Créé avec R2009b
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux
Catégories
En savoir plus sur Tables dans Help Center et MATLAB Answers
Remerciements

Inspiré par : CELL2FLOAT

A inspiré : mat2piv.m

Community Treasure Hunt

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

Start Hunting!

html/

Version Publié le Notes de version
1.2.0.0

unPivot: fixed column position in Out (the first was switched with the second)
1.1.0.0

Corrected syntax for compatibility; edited description; added link to the submission
1.0.0.0