Power Query UI Magic 🪄 (NO CODE Data Transformations)

In this video, we demonstrate the power of the UI in Power Query as we transform disorganised and chaotic data in a CSV file into beautiful tabular data for analysis in Excel.

All data transformations in the video are performed with the UI. A few clicks here and there.

No M code, no formula writing, just button pressing.

The data in the CSV file is very disorganised and the Power Query Modulus calculation performs the most impressive and important transformation in the query.

👍 Give us LIKE if you learned from this video

🔄 Share the love with your friends/colleagues by SHARING this video with them

👉 CONNECT WITH ME for more Free Excel tips

#powerquery #powerquerytutorial #dataanalysis

[alexrosen]

Great solution to a very useful tutorial 👌

[IvanCortinas_ES]

Excellent solution Alan! Thank you for sharing it.

[Luciano_mp]

I really like Power Query! Thanks Alan.

[zm]

Thank you, very useful and helpful! And practical

[chahineatallah]

Power query is the best tool ever for cleaning data, easy to learn it and very powerful and with knowledge of m code, you can do anything

[kevinshoemaker]

I watched this video and five days later I used this (while rewatching the video) for making a spreadsheet file usable. Thank you!

[sircorn]

It’s very informative.
What if an employee was not paid for a reason and had 11 payments (11 records) while all the others had 12?

[farooqtahir]

if data is not consistent like some names has 12 rows, some has 13 other have 14 then what??

[jerrydellasala]

Too expensive to post the data so someone could follow along?