# Tags **Software** : [[02 - Tags/Software/Power Query]] **Functions** used : [[Excel.CurrentWorkbook]] [[Table.ToRows]] [[Table.TransformColumns]] [[List.ReplaceMatchingItems]] **Date** : 29-March-2025 # Description 🚀 Dive into today's tutorial as we unlock the secrets of Power Query! Learn how to swiftly replace values in bulk, making your data processing smoother than ever. 📊 Whether you're dealing with errors, inconsistencies, or just need an update, this guide has got you covered. 🧠 Master the art of bulk editing in Power Query and transform your data analysis game! 🔥 # Video Link <iframe width="560" height="315" src="https://www.youtube.com/embed/dzqQ8-UQOmo?si=o55ziv9bQJ9Y_wJP" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe> [GITHUB File Link](https://github.com/jbotes/powerbiTutorials/blob/main/PQ_bulkReplace_YT_Video.xlsx) # M-Query ```mquery let Source = Excel.CurrentWorkbook(){[Name="PortfolioTable"]}[Content], StockCodeSource = Excel.CurrentWorkbook(){[Name="StockTable"]}[Content], StockCodeList = Table.ToRows(StockCodeSource), Custom1 = Table.TransformColumns(Source, {}, each List.ReplaceMatchingItems({_}, StockCodeList){0}) in Custom1 ``` ## Optional Tags **Tags** : **Technique** : [[Working with lists]]