Text Wrangling with List.Zip - Replace Masked Characters in Power Query.

In this Power Query Quick Build, we solve a small text challenge.

Column A contains strings where some letters are masked with asterisks. Column B contains the replacement characters in the correct order.

The goal: replace each asterisk with the corresponding character from column B.

Example:
String: *ave *u*!
Characters: HFn
Result: Have Fun!

This is a fast, no-narration walkthrough, showing one way to solve the challenge in Power Query using M.

Learn about List.Zip
https://youtu.be/Ei5uDoyBNV0

CODE SAMPLES
github.com/m-dekorte/melissa-de-korte-youtube-resources

CONNECT
linkedin.com/in/melissa-de-korte-64585884/

Original challenge from Excel BI:
https://www.linkedin.com/posts/excelbi_excel-excelchallenge-powerquerychallenge-activity-7031472159352832000-Z63-/

Follow up post from Meganathan Elumalai
https://www.linkedin.com/posts/meganathan-elumalai-a3449221_numerous-methods-to-accomplish-a-task-task-share-7442876964102914049-ej8g/
#PowerQuery #Excel #PowerBI #DataWrangling

Видео Text Wrangling with List.Zip - Replace Masked Characters in Power Query. канала Melissa de Korte