How can I organize/transfer existing data into a new spreadsheet?
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.
|