Extracting data from a Single Column table Using UI & M Code in Power Query Challenge 184

In this Power Query tutorial, we tackle Challenge 184, where we transform a table from a single column and extract all transactions from it. We'll demonstrate two approaches:
✅ Using the Power Query UI for a step-by-step transformation
✅ Using the M function Table.FromList for a more efficient solution
By the end of this video, you'll learn practical techniques to clean and structure data efficiently. Don't forget to like, subscribe, and comment with your thoughts! 🚀
#PowerQuery #Excel #DataTransformation #MCode #TableFromList

[@FsoOmar]

Never knew about the powerful Table.FromList function. Thank you for showing us its beauty.

[@PowerMquery]

@@FsoOmar You are welcome

[@vida1719]

This is WOW Solution!

[@PowerMquery]

@@vida1719 You are welcome

[@Excelambda]

Great solution!!
Formula alternative:
=LET(v,C3:C17,i,ISNUMBER(v),p,FILTER(v,1-i),
HSTACK(INDEX(FILTER(v,i),FILTER(SCAN(0,i,SUM),1-i)),TEXTBEFORE(p,","),--TEXTAFTER(p,",")))

[@PowerMquery]

@@Excelambda thanks

[@boissierepascal5755]

Très intéressant !

[@PowerMquery]

You are welcome

[@themolestones]

Brilliant

[@PowerMquery]

@@themolestones You are welcome

[@digitalaayam2503]

Thanks bro

[@PowerMquery]

You are welcome

[@kazembase]

آخرش هم متوجه نشدم شماره گذاری این چالش ها به چه شکلی هست؟😢

[@PowerMquery]

@@kazembase اینها در لینکدین به ترتیب شماره گذاری می‌شوند ولی اینجا نا مرتبط براشون ویدئو ضبط میشه و شیر میشه