Hi Excel experts out there

Does anyone have an idea how to solve the following issue:

How to sort/synchronise 2 data columns with missing records in one
column, so I can compare the data on the same row ?

Example of what I have:

Symbol Data1 Data 2 Symbol Data3 Data4
A 20 44 A 0.2 2
AA 22 99 AAA 0.4 3
AAA 49 48 AAC 1.2 5
AAC 43 23 AAI 3.1 4
AACB 23 75 AAIIQ 22 33
AACC 89 23
AACS 90 5
AAI 44 57
AAIIQ 22 33

What I should get done by Excel:

Symbol Data1 Data 2 Symbol Data3 Data4
A 20 44 A 0.2 2
AA 22 99
AAA 49 48 AAA 0.4 3
AAC 43 23 AAC 1.2 5
AACB 23 75
AACC 89 23
AACS 90 5
AAI 44 57 AAI 3.1 4
AAIIQ 22 33 AAIIQ 22 33

Sorry for the messy layout of the example. It should be viewed as 6
columns of 9 rows each.

Even if there's anyone who can give me a hint on where to look in the
help documentation of excel, please let me know.

Thanks a lot!
Rik


--
Rik
------------------------------------------------------------------------
Rik's Profile: http://www.excelforum.com/member.php...o&userid=31775
View this thread: http://www.excelforum.com/showthread...hreadid=514983