Transpose Data Based on Repeating Pattern in a Column in Power Query

Senior Application Development Manager, Robert Reilly, walks us through an approach to transpose data based on repeating patterns in Power Query.

You may run into a scenario where you receive data in say a CSV that needs to be transposed (Row become Columns). If you want to transpose a table it's pretty straight forward in Power Query. However, when you want to group the data in the rows by a numbered pattern like the same categories repeat every third row then it's not an out of the box operation you can do with the Power Query UI. This post will cover an approach I came up with to solve this problem.

Premier Support for Developers provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality. Contact your Application Development Manager (ADM) or email us to learn more about what we can do for