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:
table.jpg
Thanks in advance!
excel_lente!
Bookmarks