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.