Import data from a text file with pattern of rows with label and values

[fpennelli]

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!

[kersplash]

Can you attach a sample text file with enough data to test.

Also you are using Office Mac?

[fpennelli]

Yes, I use Mac office version 2016.
Attached a sample file with some test data. Unfortunately the real file has sensitive data that I cannot share.

Thank you in advance for your help!!