{"id":5945,"date":"2017-01-26T20:24:39","date_gmt":"2017-01-26T20:24:39","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/?p=5945"},"modified":"2019-02-14T20:27:41","modified_gmt":"2019-02-15T03:27:41","slug":"transpose-data-based-on-repeating-pattern-in-a-column-in-power-query","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/premier-developer\/transpose-data-based-on-repeating-pattern-in-a-column-in-power-query\/","title":{"rendered":"Transpose Data Based on Repeating Pattern in a Column in Power Query"},"content":{"rendered":"<p>Senior Application Development Manager, <a href=\"https:\/\/www.linkedin.com\/in\/robmreilly\">Robert Reilly<\/a>, walks us through an approach to transpose data based on repeating patterns in Power Query.<\/p>\n<hr width=\"100%\" size=\"1\" align=\"center\" \/>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/31\/2019\/04\/transposedata.png\"><img decoding=\"async\" width=\"644\" height=\"370\" title=\"transposedata\" align=\"right\" style=\"float: right;padding-top: 0px;padding-left: 0px;margin: 0px 0px 0px 10px;padding-right: 0px;border: 0px\" alt=\"transposedata\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/31\/2019\/04\/transposedata_thumb.png\" border=\"0\" \/><\/a>You may run into a scenario where you receive data in say a CSV that needs to be transposed (Row become Columns).\u00a0 If you want to transpose a table it&#8217;s pretty straight forward in Power Query.\u00a0 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&#8217;s not an out of the box operation you can do with the Power Query UI.\u00a0 This post will cover an approach I came up with to solve this problem.<\/p>\n<p><a href=\"https:\/\/www.linkedin.com\/pulse\/transpose-data-based-repeating-pattern-column-power-query-rob-reilly?trk=prof-post\">Read the full story here.<\/a><\/p>\n<hr width=\"100%\" size=\"1\" align=\"center\" \/>\n<p><a href=\"https:\/\/blogs.msdn.microsoft.com\/b\/premier_developer\/archive\/2014\/09\/15\/welcome.aspx\"><strong>Premier Support for Developers<\/strong><\/a> provides strategic technology guidance, critical support coverage, and a range of essential services to help teams optimize development lifecycles and improve software quality.\u00a0 Contact your Application Development Manager (ADM) or <a href=\"https:\/\/blogs.msdn.microsoft.com\/premier_developer\/contact-us\/\">email us<\/a> to learn more about what we can do for<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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).\u00a0 If you want to transpose a table it&#8217;s pretty straight forward in [&hellip;]<\/p>\n","protected":false},"author":582,"featured_media":37840,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[307,3],"class_list":["post-5945","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-permierdev","tag-powerbi","tag-team"],"acf":[],"blog_post_summary":"<p>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).\u00a0 If you want to transpose a table it&#8217;s pretty straight forward in [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/5945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/users\/582"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/comments?post=5945"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/posts\/5945\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media\/37840"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/media?parent=5945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/categories?post=5945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/premier-developer\/wp-json\/wp\/v2\/tags?post=5945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}