Hi Paddy;
? What I understood is that you have every record in two lines. In other
words, total of fields 8 but splitted in two lines. Is this also true for the
data? Eg:

name blank hire date starting salary
title blank blank current salary

Robert blank 07/14/1998 $ 50,000
Manager blank blank 75,000

Mike blank 09/03/1982 25,000
Assistant blank blank 65,000

Please confirm

Argy


"PaddyR" wrote:

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.