Pivot table

[sbussengmailcom]

Trying to format a table in  the attached example file.

[#2]

@sbussengmailcom 

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.

[#3]

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

[#4]

@sbussengmailcom 

Do you know about Power Query Power Query - Overview and Learning - Excel (microsoft.com) ?