Not sure if I have asked this question correctly, so let me explain:

I would like to convert data that I have been given, that is in this kind of format:

Forename: John
Lastname: Smith
Employee #: 62537

Forename: Fred
Lastname: Bloggs
Employee#: 63244

Forename: Pete
Lastname: Brown
Employee#: 61123

etc

Into:

Forename Lastname Employee#
John Smith 62537
Fred Bloggs 63244
Pete Brown 61123

ie the three pieces of information in row format, into a regular Excel column format

Should I get rid of all the colons after each heading first, and maybe the spaces between the records?

Any help appreciated

Wibs