Pivot table

New Contributor

Trying to format a table in  the attached example file.



3 Replies


You need unpivot columns, not pivot. That easier to do with Power Query - unpivot all weeks columns and group result by all columns but value aggregating the latest as average.

Please check attached.

Looks great but I'm not sure I follow what you did