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

Question

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

analystmate · Answer

&nbsp;&nbsp;Donald_Genes&nbsp;Here is the solution file.Download Link :&nbsp;&nbsp;&nbsp;split the 2nd row to create a new column like this screenshopt&nbsp;I would be happy to hear back from you if you have any queries&nbsp;&nbsp;

Forum Discussion

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

Share

Resources