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

Contributor

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

  

@Donald_Genes Here is the solution file.

Download Link :   split the 2nd row to create a new column like this screenshopt

 

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