I have a CSV with data exported from an old program. It created two columns. The first column contains field names and the second contains the values. It looks a bit like this:
FirstName, Paul
LastName, Smith
Birthdate, 1/1/2020
CellPhone, 123-456-789
FirstName, Mary
LastName,Smith
CellPhone, 123-555-1212
Each group starts with "FirstName", but each person in the data does not necessarily have data for each of the fields. (e.g., Mary Smith doesn't have a birthday in the system). I can use a duplicate filter to get a list of all potential fieldnames, but how do I do the next step? I want to create a table that has all the data for each person in the list. In the simplified example, two rows would result.