Unpivot Multiple Column Pairs Dynamically in Power Query

Need to unpivot repeating column pairs while keeping related values together? In this video, we reshape an HR export where Hours and Cost are repeated across separate columns for each overtime rate. A standard unpivot would separate those values into different rows, so we build a dynamic M solution that preserves each Rate, Hours, and Cost combination. Have you worked with repeating column pairs like this? Share your approach in the comments. I read them. CHAPTERS: 00:00 Expected result and source layout 01:23 Identify the pattern 02:23 Create sets of column names 05:06 Collect values for all sets 07:25 Add the Rate Type label 09:08 Turn each set into a record 10:43 Remove overtime source columns 11:35 Ascribe a new field type 13:40 Adapt the solution for grouped columns If you want to understand what Power Query is doing, not just follow steps, subscribe. CODE SAMPLES: Full step-by-step guide and resources available on GitHub. github.com/m-dekorte/melissa-de-korte-youtube-resources CONNECT: Questions? linkedin.com/in/melissa-de-korte-64585884/ #PowerQuery #Excel #PowerBI