Insert a new worksheet and put the formulae below in the cells stated:

A1: =INDIRECT("Sheet1!A"&2*ROW()-1)
B1: =INDIRECT("Sheet1!A"&2*ROW())
C1: =INDIRECT("Sheet1!C"&2*ROW()-1)
D1: =INDIRECT("Sheet1!D"&2*ROW()-1)
E1: =INDIRECT("Sheet1!D"&2*ROW())

These will give you the headings from Sheet1, but copy them down and
you will have the data arranged as you would like. You might like to
format column C as a date, and D and E as currency.

When you are done you can fix the values, and that will allow you to
delete the original data (make sure you have a backup copy of that in
case you might want it for something else).

Hope this helps.

Pete

On Nov 13, 10:44*am, PaddyR wrote:
What you say is true. *In my example, Row 1 contains cells A1 (Name) B1(empty
cell) C1 (Hire Date) & D1 (Starting Salary)

Row 2 contains cells A2 (Title) B2 (empty cell) C2 (empty cell) & D2
(Current Salary)

The second record includes the same information on Row 3 and Row 4.
The third record includes the same information on Row 5 and Row 6, etc.

In my new spreadsheet, for purposes of sorting and analysis, I need to
transfer cells A1 (described above) to A1; A2 to B1; C1 to C1; D1 to D1; and
D2 to E1.

It's also possible to perform this task by simply moving cells around in the
existing spreadsheet and adding new headings. *But, with 4,750 records I need
to find a shortcut option that works across the entire list.

Thanks for your response!

PaddR



"Argy - Arcasoft" wrote:
One more question, if what I said is true, is there any spaces in between the
data? And considering that as a true conclusion, what you really have is
(9500/2) = 4,750 records. Is this correct?

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.- Hide quoted text -

- Show quoted text -