Trick 005: Ratings for each category with power query
On Sale
$999.99
When we have a data table with many students. Each student has scores in multiple subjects. The problem is how to order the grades of each subject for each student.
To do this in excel is really difficult or must use VBA. But with Power query, this is solved easily and quickly