search the value of one column in other column and then paired it

[prthmesh111]

Input is below

Number  dbid     othid

0             7890    oth:7892

0             7891     7893

0             7892     #NA

0             7893     7356 

0              7899    some text

1234       7894     1111

1234       7895     1112

2356       7896     1113

2356       7897     1114

need to search oth id row value only for  number 0 in dbid and search the value then paired it and then create blank row in between every paired value. for eg search 7892 in the column dbid if found then bring below. and then create blank row

so my output should be :

Number  dbid     othid

0             7890    oth:7892

0             7892     #NA

0             7891     7893

0             7893     7356 

0              7899    some text

1234       7894     1111

1234       7895     1112

2356       7896     1113

2356       7897     1114

[DavidP]

Hi @prthmesh111 

Have a look at the workflow below. I can't understand why the 2 rows for 1234 and 2356 are pairs. If you can explain the logic for that I can build it in to the workflow.

[prthmesh111]

this data directly comes from the system. the number with 0 is that system has failed to get information.

[DavidP · Accepted solution]

Ok, I understand. I've updated the workflow to produce the output you need. Please see new version attached.