I have roughly 490 .txt files, each containing a contact and the contacts emails and notes exported from a CRM program. I need these .txt files imported into an excel spreadsheet, where the columns indicate the category (ID, name, email, subject, body, notes, etc.) and the individual contacts data displayed in the corresponding rows. Each text file does not contain the same data (categories), some files have only "ID" and "Email", others only "ID and Notes", others "ID, Email, and Subject" and many various combinations of the categories. The CRM program the files were exported from only exported filled in fields for each contact, so if one contact did not have any "emails" that field (category) is not included in the .txt file.
This excel spreadsheet is going to be uploaded to another CRM program (can provide name) which requires the data to be arranged in spreadsheet format where columns indicate category and rows are the contact's corresponding data. If no category is present in a contact's .txt file the category is still to be entered on the spreadsheet indicating "n/a".
Can provide more info as needed. I'm attaching an example of the .txt files I'm working with.