Rebuild a Table from a Text String - Power Query Challenge 97
Автор: How to Learn Excel
Загружено: 2025-10-12
Просмотров: 391
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/...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
