Spreadsheet Database Help

[spaz9876]

I have a database that lists in column A: Last Name, Personnel Type, Facility, User Field all going down.
In column B: First Name, Department, Blank, User Field
In column C: Initials, Employee No.

Each result has 9 blank rows before the next result.
How can I make this spreadsheet take all Last names and put in column A, First Names in Column B, Initials in Column C...etc. considering the results start every 10th row after last result ends.

[MWE]

I have a database that lists in column A: Last Name, Personnel Type, Facility, User Field all going down.
In column B: First Name, Department, Blank, User Field
In column C: Initials, Employee No.

Each result has 9 blank rows before the next result.
How can I make this spreadsheet take all Last names and put in column A, First Names in Column B, Initials in Column C...etc. considering the results start every 10th row after last result ends.
This is not as hard to do as one might initially think. My approach would be:
1. delete any blank rows; that should leave nothing but data in cols A, B and C
2. parse out LastName, ... from A, FirstName, ... from B and Initials, ... from C.
3. write the strings back to Cols A, B, C, D, ...
4. add in whatever appearance options are desired, e.g., headers, borders, etc.

The only complicating factor is what is used to separate stuff in the original cells. Given your statement that the items are "going down", it is probably some sort of CR or LF (perhaps preceeded by a comma). If you can post a sample spreadsheet (sanitized as appropriate), I can easily put together something for you.