Hi here comes my problem:

There are two colums, name and number, in my two excels A and B and I want to merge them using "Merge Data". However there are some arrays in A which have the same property "name", like line one to three are all "Jack" as the name property with no number. And I want to merge the correspond number 5 of Jack from B to A, while pipeline automatically writes the correspond number only once. So after merging my excel, there is only one line left with jack and the number. Initially I wanted to append all the empty numbers to jack in every line in excel A with no deletion of lines. So how can I modify the parameters so that I can achieve my purpose?

Thanks!

This is the format what I wanted after merging

This is the actual format after merging