APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table

APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table

12.895 Lượt nghe
APQ08: Power Query List Functions - Bulk Replace values in a table using a helper table
#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