software

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:

SymbolData1Data 2SymbolData3Data4
A 2044A0.22
AA 2299AAA0.43
AAA 4948AAC1.25
AAC 4323AAI3.14
AACB2375AAIIQ2233
AACC8923
AACS905
AAI4457
AAIIQ2233

What I should get done by Excel:

SymbolData1Data 2SymbolData3Data4
A2044A0.22
AA2299
AAA4948AAA0.43
AAC4323AAC1.25
AACB2375
AACC8923
AACS905
AAI4457AAI3.14
AAIIQ2233AAIIQ2233

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: www.excelforum.com/member.php...oamp;userid=31775
View this thread: www.excelforum.com/showthread...hreadid=514983One way to do it would be to sort dataset 1 into your preferred layout,
and then use VLOOKUP to pull dataset 2 into that layout. By nesting
VLOOKUP into an IF statement you could return blanks instead of #N/A
(which is what returns when no match is found).

The problem with this idea is that it only works if all the elements in
dataset 2 are also in dataset 1. If dataset 2 contains any elements
that are not in dataset 1, those elements will not be considered.
Hi Dave,

Thanks a lot for your help!
I could solve my issue. I did it slightly different (LOOKUP instead of
VLOOKUP), but you put me on the right track and it's working!

Much appreciated
Rik--
Rik
------------------------------------------------------------------------
Rik's Profile: www.excelforum.com/member.php...oamp;userid=31775
View this thread: www.excelforum.com/showthread...hreadid=514983
Hi Dave,

Thanks a lot for your help!
I could solve my issue. I did it slightly different (LOOKUP instead of
VLOOKUP), but you put me on the right track and it's working!

Much appreciated
Rik--
Rik
------------------------------------------------------------------------
Rik's Profile: www.excelforum.com/member.php...oamp;userid=31775
View this thread: www.excelforum.com/showthread...hreadid=514983