Matching rows

[MonaAlmutairi]

Hello everyone,

I'm having a little issue matching my data, see below example

Before:

D1	D2
0	44
0	55
123
0	11
0	11
0	22
0	33
456
789
741

After (what I want):

(Match D1 with only data in the upper rows, and remove duplicate in D2)

D1	D2
123	44
123	55
456	11
456	22
456	33
789	11
789	22
789	33
741	11
741	22
741	33

Thank you in advance!

[Emmanuel_G · Accepted solution]

Hi @MonaAlmutairi ,

Find attached the solution to this issue.

[MonaAlmutairi]

@Emmanuel_G Thank you for your efforts!