Merging data without VLOOKUP

New Contributor

Hello,

 

I have an issue with Excel, I have to merge data but I can't use VLOOKUP because it's not showing duplicates.

 

Here is the data I have:

EXGSTBSSSSTB
EXG_SSI_1500STB_SSI_01300SSS_TEST_00802STB_SSI_01300
EXG_SSI_1500STB_SSI_01490SSS_TEST_00470STB_SSI_01670
EXG_SSI_1650STB_SSI_01470SSS_TEST_00471STB_SSI_01670
EXG_SSI_1655STB_SSI_01470SSS_TEST_00802STB_SSI_01000
EXG_SSI_1500STB_SSI_01270SSS_TEST_00472STB_SSI_01270
EXG_SSI_1001STB_SSI_01670SSS_TEST_00802STB_SSI_01200

 

And here is what I'd like to have.

EXGSTBSSS
EXG_SSI_1500STB_SSI_01300SSS_TEST_00802
EXG_SSI_1001STB_SSI_01670SSS_TEST_00470
EXG_SSI_1001STB_SSI_01670SSS_TEST_00471
 STB_SSI_01000SSS_TEST_00802
EXG_SSI_1500STB_SSI_01270SSS_TEST_00472
 STB_SSI_01200SSS_TEST_00802
EXG_SSI_1500STB_SSI_01490 
EXG_SSI_1650STB_SSI_01470 
EXG_SSI_1655STB_SSI_01470 

 

Thx !

1 Reply

If I try XLOOKUP, here is the result:

EXG_SSI_1500STB_SSI_01300SSS_TEST_00802
EXG_SSI_1001STB_SSI_01670SSS_TEST_00470
EXG_SSI_1001STB_SSI_01670SSS_TEST_00471
0STB_SSI_01000SSS_TEST_00802
EXG_SSI_1500STB_SSI_01270SSS_TEST_00472
0STB_SSI_01200SSS_TEST_00802
EXG_SSI_1500STB_SSI_01490 
EXG_SSI_1650STB_SSI_01470 
EXG_SSI_1650STB_SSI_01470 

 

The last one should be EXG_SSI_1655 and not 1650...

 

Any idea ?

 

Thanks !