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.

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?



"PaddyR" wrote:

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.