Fill out the blank

Question

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.

Fill out the blank.xlsx

atcodedog05 · Answer

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 : )

Update Remarks Columns.yxmd

Yoshiro_Fujimori · Answer

@binu_acs

Oops, I did not know you were already there.

Excuse me 😅

Yoshiro_Fujimori · Answer

@SH_94

How about this solution?

FillOutBlank.yxmd