Parsing Key Value pairs from inconsistent and incomplete data

[excel_lente]

Hey all,

I have a CSV file with the following data in rows:

{'gender': 'male', 'age': '35', 'hometown': 'Chicago', 'car': 'Civic', 'occupation': 'actor', 'salary': '80000'}

{'gender': 'male', 'age': '32', 'hometown': 'New York', 'occupation': 'banker', 'salary': '130000'}

{'gender': 'female', 'age': '33', 'hometown': 'Seattle', 'occupation': 'developer'}

{'age': '27', 'hometown': 'Detroit', 'car': 'Mustang', 'salary': '75000'} As you can see, there are recurring attributes (i.e. Gender, Age, Hometown, Car, Occupation, Salary), but this data is complete for every record, making it difficult / impossible to simply separate via Column-To-Test techniques. Is there a way to use Excel to parse this data into columns and rows? I'd like to use the attributes as column headers, so that when a "value" is missing, it would simply be a blank cell: gender age hometown car occupation salary Male 35 Chicago Civic Actor 80000 Male 32 New York Banker 130000 Female 33 Seattle Developer <tbody> </tbody> Thanks in advance!

<tbody>
</tbody>

excel_lente

Also posted
https://www.excelforum.com/excel-ge...rs-from-inconsistent-and-incomplete-data.html