Join two data set with some duplicate value

Question

Hi community,

I would like to seek for assistance on the following type of data and the output desired:

If there are more than one same ID in the data - Input 2 , the output will populate customer detail  by adding * at the behind of each word and also populate the value as zero for those additional line under the amount column

Many thanks

Merging two set data with some duplicate.xlsx

SH_94 · Answer

Hi @ShankerV ,

Many thanks for the prompt response.

Would like to ask how do we settle the following type of input data:

Thank you.

Christina_H · Answer

Actually, you want all customer rows marked if there are duplicates, here's an update that does that.

Join with duplicates.yxmd

Christina_H · Answer

You could use a couple of multirow formula tools to set the values.  I've used a tile tool and single formula tool instead.

Join with duplicates.yxmd