Forum Discussion
Donald_Genes
Nov 02, 2022Brass Contributor
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
- AnalystmateCopper Contributor
Donald_Genes Here is the solution file.
Download Link : https://analystmate-my.sharepoint.com/:f:/p/lavdeepsharma/Eoc1oJBV5ExKvHQWn4t2AJ4BDaGX4DoFnq6SK_syeG0xkg?e=kcSxdCI would be happy to hear back from you if you have any queries