Create Dynamic Columns – Power Query Challenge

This challenge is inspired from a challenge that Wyn Hopkins recently posted on his blog.

Video – Create Dynamic Columns in Power Query

Consider this simple dataset

Nothing to explain here, I guess!

The Expected Output

• As an output I need a table with all unique Hobbies as columns.
• And a TRUE flag as a value under the column, if the person is pursuing that hobby. For instance, Rehet is marked TRUE for Python and Monkey Bars.
• The output should dynamically expand the (hobbies) columns or (names) rows if new data kicks in.

Download Data

Rules

1. Solve this using Power Query.
2. Minimize the number of Steps.
3. Post your M Code in the comments.