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

Опубликовано: 03 Октябрь 2024
на канале: AAA Excel’s Power

10,137

309

#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
   • Advanced Power Query
--------------------------------------------------------------------------------------
To download the working files:
https://drive.google.com/drive/folder...
--------------------------------------------------------------------------------------
To subscribe:
   / @aaaexcel
--------------------------------------------------------------------------------------
To follow on Facebook
  / excelispower
--------------------------------------------------------------------------------------
To follow on LinkedIn:
  / amratef