Rebuild a Table from a Text String - Power Query Challenge 97

Rebuild a Table from a Text String - Power Query Challenge 97
In this Power Query challenge, we take a single cell packed with dates and sales like
2024/7/20/63/2024/7/21/29/...
and turn it into a clean, structured table with Date and Sale columns.

You’ll see how to use Splitter.SplitTextByDelimiter, List.Split, Text.Combine, and Table.FromList — step by step — to rebuild data that looks impossible to clean.

Try it yourself and post your version in the comments!

Explore more tutorials:
🎥 Power Query Challenges Playlist:
https://www.youtube.com/playlist?list=PLDmmlQOC_xTW0FbOs6JrIaKhUFZbXbcfa
🎥 Dynamic Array Formulas Playlist:
https://www.youtube.com/playlist?list=PLDmmlQOC_xTVqF4T-6bLaEjRGpZP8CnZC

#PowerQuery #ExcelTips #HowToLearnExcel

Links:
Challenge Author: Omid Motamedisedeh
LinkedIn: https://www.linkedin.com/in/omidmot
Challenge Post: https://www.linkedin.com/posts/omidmot_exclude-powerabrquery-excel-activity-7382157929879310336-AukO
Solution: https://docs.google.com/spreadsheets/d/1P65H4g1ZBRgQzdlgE1H6VyArHruIMHp3?rtpof=true&usp=drive_fs

Видео Rebuild a Table from a Text String - Power Query Challenge 97 канала How to Learn Excel