How to make CSV headers and Keys the column names in JSON output?

Given this CSV file which is a mix of column values + key, value pairs. How would you filter these information such that the headers at the top of the CSV become the column names, and the Keys in key, value pairs become the column names as well?

This is my current result, I don't know how to convert the key into a column, if you have a look at colmn76, you realize that it is a key for the value in column77 because they are key, value pairs.

Please do not post pictures of text. Just post the text.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.