APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table
Channel: AAA Excel’s Power
Date: 2022-12-17

#exceltips  #powerquery #exceltutorial #msexcel 
Website: www.aaa-power.net
--------------------------------------------------------------------------------------
Chapters:
0:00 Intro
1:15 Explain the function: List.RepalceMatchingItems
6:16 Convert a record to a list
8:00 Convert a table to lists
9:46 Bulk replace values using List.RepalceMatchingItems
11:37 Convert group of lists to a table
16:00 close
--------------------------------------------------------------------------------------
To watch the full playlist
https://youtube.com/playlist?list=PL5NlUYOM2iOjRsboi_z9cHTyM7yqwWu58
--------------------------------------------------------------------------------------
To download the working files:
https://drive.google.com/drive/folders/1MvShYClXcM3fckStDjxFJpeRQo7QRPEu?usp=sharing
--------------------------------------------------------------------------------------
To subscribe:
https://www.youtube.com/channel/UCqwLHNFtrOjrOC3CnvviS1g?sub_confirmation=1
--------------------------------------------------------------------------------------
To follow on Facebook
https://www.facebook.com/excelispower
--------------------------------------------------------------------------------------
To follow on LinkedIn:
https://www.linkedin.com/in/amratef