Fill out the blank

[SH_94]

Hi community,

May i know how to fill out the blank for the following scenario? If there is same number appear but for the remark column, it is missing for certain row.

So in order to fill in the missing part, if there is same number appeal , and one of the row have details, then we will copy it and past in the missing row.

Thank you.

[binuacs]

@SH_94 One way of doing this

[Yoshiro_Fujimori]

@SH_94 

How about this solution?

[Yoshiro_Fujimori]

@binuacs 

Oops, I did not know you were already there.

Excuse me 😅

[atcodedog05]

Hi @SH_94 

Here is how you can do it.

1. Data, where Remarks is not empty, can be used as a reference data

2. Vlookup the main data with the reference data to update remarks

Learn more on how to perform vlookup similar to excel in Alteryx: https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201 

Hope this helps : )