★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Check out the blog post★
exceloffthegrid.com/power-query-replace-values-from-list/
★ About this video ★
A few weeks ago, I posted about using Excel's REDUCE and SUBSTITUTE functions to perform multiple find and replace actions to create dynamic text.
But what if we want multiple find and replace during the data-cleaning process? In that scenario, we need to use Power Query to replace values based on a list. So, in this post, let's find out how to do that.
CONTENTS
0:00 Introduction
0:46 Replace values based on a list
6:59 Conclusion
Link to post by Rick De Groot:
gorilla.bi/power-query/list-accumulate/
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: twitter.com/exceloffthegrid
#MsExcel
- Power Query: How to mass replace values based on a list | Excel Off The Grid ( Download)
- Replace Values Based on Condition (in a Single Step) in Power Query ( Download)
- Power Query Replace Values the safer way ( Download)
- Power Query - Bulk Replace Values in One Step 🔄📊 ( Download)
- Power Query: Bulk Replace Values from a table in Excel & Power BI ( Download)
- Bulk Replacements (Replace Multiple Values in a Table at once) in Power Query ( Download)
- 4 METHODS to Filter by a List in Power Query | Excel Off The Grid ( Download)
- APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table ( Download)
- Replace values faster in Power Query: 4 tips ( Download)
- Replace column names of nested tables using Power Query | Excel Off The Grid ( Download)
- Replace multiple values in Power Query in one step ( Download)
- Replace Values in Multiple Columns Based on Condition in Power Query ( Download)
- Power Query Tutorial: How to Conditionally Replace Values Without Creating New Columns ( Download)
- Transform Column Names in Bulk in Power Query ( Download)
- Replace Multiple Column Values in One Step [Power Query Tips & Tricks] ( Download)
