Power Query: How to mass replace values based on a list | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post★
https://exceloffthegrid.com/power-que...
★ 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:
https://gorilla.bi/power-query/list-a...
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel