Convert One Column Of Data To 257 Columns Of Data

I have exported a text file from a universe database and need to import it into excel.

Below is an eg of one section. The text file contains approx 257 of these, all one below the other.

Between each set of dotted lines is one user profile (not data all shown in eg) .

Each one (user) is NOT the same amount of lines(rows) deep and only the dotted lines separate each user.

A simple import places all data into one very long column.

I need a way to place each user in there own column.

I have user names as column headings the labels of the values below as row headings. I cannot change this.

Manually entering the data took a very long time and i need to update this workbook regularly.

In the text file, " the variable......: value " (eg UserCode.....: XYZ) sets are all lined up so that using a text editor, with column mode, I can delete all the data headings/labels up to the space after the colon.
This leaves me with 7000 rows of values (eg XYZ) one column wide and various numbers of rows deep per user.

Is there a way to import the data and seperate each user via the dotted lines or other so that each users data is contained in consecutive columns. 1 user profile per column.

The standard import utility allows for column placement (delimted, fixed width). Can this be done on rows, sort of flip it 90 degrees and use the dotted lines as column markers. Just guessing now. Any and all assistance would be most appreciated.

Another issue (not as important but still helpful) is that the "procudures barred" section of user profile can also be one row(line) or serveral. Problem is each Name...:Value set must be on one row(line) for everything to match in the work book.

Using custom macros in my text editor i moved all the 'proc. barred' data to a single row. Alot of manual editting was involved and any ideas on this area would also be muchly appreciated.

One EG user profile (not shown, but all the colons line up) ....