I have a problem with Unpivot / Pivot.
After reading several files (in example 5) and Unpivot/Pivot, only one line is displayed after the PivotAction.
I would have expected 5 lines. Why aren’t 5 rows of data displayed?
the “Any” aggregation means that among values of the same column only one (literally any) will be taken and the rest discarded (lost).
What you could do is add grouping before pivoting. Groups are defined by a combination of all columns that are not data or labels. Usually, you just enumerate rows before pivoting. Rows should be enumerated within groups specified by column “Labels”.