{"id":324,"date":"2023-01-20T09:21:54","date_gmt":"2023-01-20T09:21:54","guid":{"rendered":"https:\/\/grionic.com\/?p=324"},"modified":"2023-01-20T09:21:56","modified_gmt":"2023-01-20T09:21:56","slug":"convert-row-to-column-in-power-query","status":"publish","type":"post","link":"https:\/\/grionic.com\/convert-row-to-column-in-power-query\/","title":{"rendered":"How to Convert Row to Column in Power Query"},"content":{"rendered":"\n
Have you ever wondered how you can convert a row to a column in Power Query? This article teaches you the easiest approach to achieving this.<\/p>\n\n\n\n
Let’s get started.<\/p>\n\n\n\n
Introduction<\/h2>\n\n\n\n
To get started, insert your data into Power BI. Select the worksheet you want to work with, and click on Transform Data<\/strong>. <\/p>\n\n\n\n
For this tutorial, I will make use of Excel data with Alternate Rows<\/strong> (as displayed below). You can download the data here<\/a>.<\/p>\n\n\n\n