This is 5th in series of Power Query Challenges. Given the height and width, you need to generate the Multiplication Table. In the example. Height is 20 and width is 8, hence multiplication table columns should be from 1 to 8 and each should contain 20 rows.

This is another interesting Power Query Challenge. Extract the digits from the given string and sum the digits for that extract string in each row.

There is a table which has Original Text and there is another table which contains the list of words which need to be replaced. Original text should be replaced with words from lookup table.

Here comes the challenge. The Subjects table has list of subjects. The words are separated by either comma or space and amount of space is also not uniform. The case of subjects is also not uniform. The count of rows for subjects is needed

Here comes the Power Query challenge. The count of words in each row is needed. The challenge is that the solution has to be completely UI (user interface) driven. After loading the table in PQ, you should not press even a single key to come up with the result. You should use only mouse.