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.
39494 126842The electronic cigarette uses a battery and a small heating factor the vaporize the e-liquid. This vapor can then be inhaled and exhaled 586248
873930 317552Your writing taste has been amazed me. Thank you, very nice post. 925128
890664 420041This write-up is dedicated to all those who know what is billiard table; to all people who do not know what is pool table; to all people who want to know what is billiards; 420967