Forum Discussion
help needed with power query transform
i have a excel spreadhseet with one of the column like in the screenshot below. I tried to transform to JSON but its throwing error. How to expand those columns inside the brackets .
Anonymous Make a json where all of these are objects, then just uploading the data through json should do the work.
I am getting this data from excel spreadsheet in this format. How to make json from this data?