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.