Forum Discussion
Statistics Table
- 6 years ago
You could unpivot your data. Open power query, highlight all columns, right click and unpivot. This will give you attribute and value. You can add Attribute to the rows of a table, then drag in value four times and change the summarization to the correct measure.
Appreciate your Kudos
Connect with me!Stay up to date on
Read my blogs on
You could unpivot your data. Open power query, highlight all columns, right click and unpivot. This will give you attribute and value. You can add Attribute to the rows of a table, then drag in value four times and change the summarization to the correct measure.
Appreciate your Kudos
Connect with me!
Stay up to date on
Read my blogs on
- Anonymous5 years agoNot applicable
Hi,
Thank you for this help.
Is it possible to copy the data before unpivot it in order to obtain a file of the form?
FORM / INSTANT / TREATMENT / TEMPERATURE / FRAC / ATTRIBUTE / VALUES
38.2 / 31.7 / 47.3 / 32 / FORM / 38.2
39.9 / 32 / 47.7 / 33.5 / INSTANT / 31.7
etc
Thanks 🙂