You would need to clean the data to give the result in picture.
Try to do maximum steps through UI and minimize formula / M-code.
The problem file related to this challenge can be downloaded from PQ_Challenge_7_Problem
The solution to this Clean the data – Power Query Challenge 7 will be published after a week i.e. on Tuesday, 19-Oct-21.
Solution link – Solutions to Power Query Challenges – 1 to 7 M
Hi there. I do not see where the answer to this has been posted.