Find/Replace in Bulk in 3 steps Using Table.TransformColumns() & List.ReplaceMatchingItems() P.Query
2:27
YouTubeJosh_Excel
Find/Replace in Bulk in 3 steps Using Table.TransformColumns() & List.ReplaceMatchingItems() P.Query
#powerquery #power_query 1. Create/import two tables: • T1 for the Data to be modified • T2 for the Find/Replace list 2. Use Table.ToRows() function on T2 to make a list of lists for each Find/Replace pair (F_R) 3. Use Table.TransformColumns() and List.ReplaceMatchingItems() functions • Values need to be put into a list by using curly ...
431 viewsApr 11, 2023
Power Query Basics
Excel Power Query Course: Power Query Tutorial for Beginners
1:49:28
Excel Power Query Course: Power Query Tutorial for Beginners
YouTubeSimon Sez IT
978.2K viewsMay 18, 2020
How to use Microsoft Power Query
16:35
How to use Microsoft Power Query
YouTubeKevin Stratvert
3.2M viewsNov 24, 2020
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
28:07
Power Query for Beginners: Transform Excel Data in Minutes (2025 Tutorial Part I)
YouTubeJosh Aharonoff (Your CFO
249.6K viewsJan 15, 2025
Top videos
Power Query |M Language |How to use Repeat,ReplaceRange,ReplaceValue, ReplaceMatchingItems functions
11:44
Power Query |M Language |How to use Repeat,ReplaceRange,ReplaceValue, ReplaceMatchingItems functions
YouTubeMarchetty Pavan Sai
309 viewsApr 13, 2023
Power Query: How to mass replace values based on a list | Excel Off The Grid
7:41
Power Query: How to mass replace values based on a list | Excel Off The Grid
YouTubeExcel Off The Grid
51.6K viewsAug 3, 2023
Power Query - Bulk Replace Values in One Step 🔄📊
4:22
Power Query - Bulk Replace Values in One Step 🔄📊
YouTubeBA Sensei
9.6K viewsAug 15, 2023
Power Query Advanced Techniques
5 Advanced Power Query Tricks Every Data Analyst Should Know | PBI & Excel Users | Download PBIX
29:40
5 Advanced Power Query Tricks Every Data Analyst Should Know | PBI & Excel Users | Download PBIX
YouTubeAnalytical Guy
244 views2 months ago
30 Power Query Tricks Most Excel Users Don't Know
58:46
30 Power Query Tricks Most Excel Users Don't Know
YouTubeTrumpExcel
6.1K views4 weeks ago
Power Query Tutorial - Beginner to Advanced [Full Course]
1:54:31
Power Query Tutorial - Beginner to Advanced [Full Course]
YouTubePivotalstats
17.2K views8 months ago
Including results for power query list replace matching items.
Do you want results only for Power Query List Replacematchingitems?
Power Query |M Language |How to use Repeat,ReplaceRange,ReplaceValue, ReplaceMatchingItems functions
11:44
Find in video from 08:26Replace Matching Items Function
Power Query |M Language |How to use Repeat,ReplaceRange,Replac…
309 viewsApr 13, 2023
YouTubeMarchetty Pavan Sai
Power Query: How to mass replace values based on a list | Excel Off The Grid
7:41
Find in video from 01:18Creating a List
Power Query: How to mass replace values based on a list | Excel Off T…
51.6K viewsAug 3, 2023
YouTubeExcel Off The Grid
Power Query - Bulk Replace Values in One Step 🔄📊
4:22
Find in video from 01:04Converting the List to a List
Power Query - Bulk Replace Values in One Step 🔄📊
9.6K viewsAug 15, 2023
YouTubeBA Sensei
The Fastest Replace Values method using a list in Power Query
32:18
The Fastest Replace Values method using a list in Power Query
11.6K viewsOct 17, 2024
YouTubeAccess Analytic
Replace Several Values in a Column in Power Query with One Step
4:41
Replace Several Values in a Column in Power Query with One Step
1.4K views5 months ago
YouTubeOmidBI
Bulk Replacements (Replace Multiple Values in a Table at once) in Power Query
1:47
Bulk Replacements (Replace Multiple Values in a Table at once…
3K viewsFeb 22, 2023
YouTubeBhavya Gupta
30 Power Query Tricks Most Excel Users Don't Know
58:46
30 Power Query Tricks Most Excel Users Don't Know
6.1K views4 weeks ago
YouTubeTrumpExcel
6:01
Power Query Tutorial: How to Conditionally Replace Values With…
15.8K viewsApr 2, 2023
YouTubeTECHQI
35:17
Power Query - Beginner to PRO Masterclass in 30 minutes
455.2K viewsAug 13, 2024
YouTubeChandoo
2:58
Replace multiple values in Power Query in one step
119.7K viewsJul 13, 2020
YouTubeCurbal
10:39
Find in video from 00:26Exact Match Example
VLOOKUP in Power Query Using List Functions
229.5K viewsJul 29, 2021
YouTubeMyOnlineTrainingHub
16:16
Find in video from 03:07Converting Columns to Lists
APQ08: Power Query List Functions - Bulk Replace values in a table u…
15.2K viewsDec 17, 2022
YouTubeAAA Excel’s Power
12:17
Power Query: Bulk Replace Values from a table in Excel & Power BI
30.5K viewsMar 18, 2022
YouTubeDavid Benaim
19:24
Find in video from 02:26Introduction to List.Accumulate()
Multiple Find / Replace with List.Accumulate() ~ Power Query
41.1K viewsMay 14, 2020
YouTubeChandoo
12:13
Power Query Pro Tip: Lookup Keywords & Assign Categories Au…
2.2K viewsMay 2, 2025
YouTubeAnser's Excel Academy
3:18
Replace Unique Values - Power Query Challenge 110
456 views3 months ago
YouTubeHow to Learn Excel
5:14
Find in video from 00:12Removing Matching Rows with List
Power Query | M Language | How to Remove or Replace Matching Row…
591 viewsApr 26, 2023
YouTubeMarchetty Pavan Sai
11:39
Power Query - Exact Match Lookups (1 Goal; 3 Methods)
7.1K viewsOct 22, 2024
YouTubeBCTI
7:49
Power Query - How to Replace Errors in Columns That Don't Exis…
372 views2 months ago
YouTubeDoug H
8:37
Partial Match in Excel's Power Query - Fuzzy Match EXPLAINED
20.6K viewsNov 26, 2022
YouTubeAnser's Excel Academy
3:39
Find in video from 02:09Replace Each and Every Set by Finding the First Character
Power Query - "SUBSTITUTE" function: Replace a set of strings …
1.1K viewsJun 5, 2019
YouTubeGuru - 'G'
10:18
Rename columns in Power Query when names change | Excel Off Th…
26.7K viewsJan 13, 2022
YouTubeExcel Off The Grid
3:21
Find in video from 02:20Matching Entire Cell Contents
Excel Find And Replace Trick. (Match Entire Cell Contents)
96.7K viewsNov 30, 2020
YouTubeHow To Excel At Excel.Com
4:53
Find in video from 00:56Loading Data into Power Query
Power Query - Combine rows into a single cell | Change data to readab…
165K viewsJun 13, 2020
YouTubeExcel Off The Grid
12:14
Power Query Parameters - Dynamically Change the Output o…
107.9K viewsMar 26, 2022
YouTubeMiss Microsoft
6:53
Find in video from 02:38Adding Another Column and Replacing Matching Items
Power Query - List.Buffer to do a Million row Lookup
18.2K viewsMar 11, 2024
YouTubeBA Sensei
23:31
Excel - Match Closest Partial, Misspelled Text Value - Fuzzy Mat…
48.2K viewsJul 20, 2020
YouTubeLearn Google Sheets & Excel Spreadsheets
6:51
Find in video from 01:46Creating a List of Rows
Using the List technique in Power Query to recombine tables
11.1K viewsAug 16, 2024
YouTubeAccess Analytic
0:45
Data Transformation: Data Cleaning/Replace Values in Powe…
7.7K viewsFeb 20, 2024
YouTubeKnowHow Academy
See more videos
Static thumbnail place holder