Merge Columns in Power Query Dynamically Based on Name Patterns
Learn how to merge multiple columns in Power Query when they share a similar name (e.g., A 1, A 2, A 3). In this step-by-step tutorial, I’ll show you how to:
✅ Unpivot columns into rows
✅ Remove or clean extra characters from column names
✅ Pivot the data back to merge columns by their base name
This method is perfect for cleaning and reshaping messy datasets in Excel or Power BI.
00:00 Introduction
00:53 Unpivoting the columns
01:15 Cleaning Column Names
02:05 Pivoting