Nov 02 2022 03:01 AM
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
Nov 02 2022 11:16 AM - edited Nov 02 2022 11:21 AM
@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