Power Query - to merge rows and calc avrg on the other columns

Question

I haven't found this issue anywhere and it should be easy...

I have a table with the first column weeks numbers and in all the other columns values.
I have multiple rows with the same week number and different values in the other columns

I would need to merge all the rows with the same week number (so to have one row per week) and for each other column to have the average values calculated for that week...

I would like to have it done in the PQ so I can get the calculated table in the excel sheet.

Thanks a lot for your help!

Answer 1

Hi there. Power Query is no longer supported here on Q&A. Please post your question on https://aka.ms/PQCommunity.