That's the problem, there are no blanks - So when I sort the 2nd set of data,
it occupies a different area on the worksheet to the 1st set of data.
EG
Set1 Set2
Ref# Data1 Ref# Data2
A1 2.3 A1 4
A2 2.2 A4 3
A3 2.4 A6 3
A4 2.7 A9 5

I need to sort set 2 so that the ref#'s are in the same row as they are in
set 1.

Like this

Set1 Set2
Ref# Data1 Ref# Data2
A1 2.3 A1 4
A2 2.2
A3 2.4
A4 2.7 A4 3

Any ideas?

"R..VENKATARAMAN" wrote:

didi you try sorting column A of sheet2 sothat the blanks will come down.


"Ting" wrote in message
...
I have two large sets of data on the same worksheet. One is complete (A1,
A2,A3 etc) and the other has irregular ommisions (A1,A5,A7 etc). How do I
sort the data so that A123 from the first set is in the same row as A123
from
the 2nd set? I need to be able to transpose data from the 2nd set onto the
1st whilst maintaining it's relationship to the refference numbers (A1, A2
etc). I am using excel 2002. I'm sure that this is a simple question but I
can't figure it out.