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

name blank hire date starting salary
title blank blank current salary

I need to reorganize this information into a single line format which reads:

name title hire date starting salary current salary

Because of the length of the document I need to find the best, automatic way
to accomplish this change. I'm new to Excel 2007 so would be grateful for
any, simplified assistance.