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:
   • Power Query: Challenges  
🎥 Dynamic Array Formulas Playlist:
   • Modern Excel Challenges  

#PowerQuery #ExcelTips #HowToLearnExcel

Links:
Challenge Author: Omid Motamedisedeh
LinkedIn:   / omidmot  
Challenge Post:   / omidmot_exclude-powerabrquery-excel-activi...  
Solution: https://docs.google.com/spreadsheets/...