Forum Discussion

Donald_Genes's avatar
Donald_Genes
Brass Contributor
Nov 02, 2022

Quick one -is there a way to split the 2nd row to create a new column like this screenshopt?

I have been using sql and python like a lot and now i literally forgot a bit about power query 

so, i want to the second row which is address to become a column like this

Company Name | Facility Name | Address | Reference etc

 

 

1 Reply

  • Analystmate's avatar
    Analystmate
    Copper Contributor

      

    Donald_Genes Here is the solution file.

    Download Link :   https://analystmate-my.sharepoint.com/:f:/p/lavdeepsharma/Eoc1oJBV5ExKvHQWn4t2AJ4BDaGX4DoFnq6SK_syeG0xkg?e=kcSxdC

     

    I would be happy to hear back from you if you have any queries

     

     

Resources