I have a text file with the following pattern
*************************** 1. row ***************************
landlordFirstName: Sam
landlordLastName: Smith
rentDueDay: 2
rentAmount: 100.0000
tenantFirstName:John
*************************** 2. row ***************************
*landlordFirstName: Tom
landlordLastName: Doe
rentDueDay: 1
rentAmount: 200.0000
tenantFirstName:craig
*************************** 3. row ***************************
.... etc
I'd like to be able to import it into excel and have a table with the lables as columns and the values listed below
Any kind soul who may be willing to help me?
Thanks in advance!
Bookmarks