How can I organize/transfer existing data into a new spreadsheet?

[PaddyR]

I have a large spreadsheet (9500 lines) with data organized in the following
way:

name blank cell hire date starting salary
title blank cell blank cell current salary

I need to reorganize this information into a single, more efficient format
with the following headings:

name title hire date starting salary current salary

Because of the length of the document cut and paste is out of the question.
Can I use a macro or is there another way to reorganize the data? Thanks in
advance for any help you can provide.

 

[Sheeloo]

Do you have
name blank cell hire date starting salary in one row (name, blank,
hire-date, starting-salary) and
title blank cell blank cell current salary in second row?

Are there blank rows between two sets of data?