I have a few text files that contain repetitive data that I want to be able to import into a spreadsheet.

An example of the data is:

Name: Joe Smith
Address: 123 S. Street
City: New York
Phone: 1231231234
Name: Sam Jones
Address: 321 S. Street
City: New York
Phone: 3213214321

I have multiple sets of similar data contained in multiple text files. I would like to create a template that I point to a single text file and import the data so that it looks like this:
Name Address City Phone
Joe Smith 123 S. Street New York 1231231234
Sam Jones 321 S. Street New York 3213214321

All the data is delaminated by a colon and I can get it into rows but I want to be able to sort and I don’t want the data to the left of the colon repeated.

Any help would be appreciated.

Thanks

Scott