Hello! I am new to Power Query! I want to calculate the average (mean) of the grades for each student across each of their modules. (This data is psuedonymised). But I want to make it so that a new line is inserted under each set of the same student, like this: Is this possible? Many thanks! Paula

It can be done, but I don't recommend you to do it now because it requires writing some code, and I believe writing code is not a good thing for a novice. If it is just to solve your problem, the pivot table can do it.

How to calculate averages using power query in excel

Forum Discussion

16 Replies

Related content