Power Query Challenge 6 is following – Generate the result table from Alphabets table. Columns are sorted hence first column is A, second column is B and so on. In real life situations, alphabets would be replaced with words but to keep the problem simplified, I have used alphabets.
Of course, the query should be dynamic i.e. even if number of alphabets increase or decrease in the table or no. of rows increase or decrease, the Query should give right result on Refresh.
I hope you grasped Power Query Challenge 6 and will enjoy doing this problem in this series of Power Query Challenges.
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_6_Problem
The solution to this problem will be published after a week i.e. on Monday, 18-Oct-21.
Solution link – Solutions to Power Query Challenges – 1 to 7
Power Query M function reference – PowerQuery M | Microsoft Docs
Quiero adquirir archivos
File link is at the bottom of the post.
El enlace del archivo está en la parte inferior de la publicación.