Add custom column based on column id and field value

[Zabeer]

Hello, 
I have a requirement to add a column that takes values from a field in another column.
Example-

In other words, the new column should take the FieldValue of 'Vendor'  for each unique RowID.
I would need this in Power Query. Kindly help.

Thanks.

[Zabeer]

@Fowmy : Thanks for your reply. What parameters do I then need to invoke the function?

[Fowmy]

@Zabeer 

You can click Column Column, paste the above code, click OK  then remove the word  "each" in the formula   bar

[Fowmy · Accepted solution]

@Zabeer 

You can add custom column in PQ as follows: Replace "Previous Step" with your last step in the query

(x)=> Table.SelectRows(#"Previous Step", (y)=> y[ColumnID]  = x[ColumnID] and y[Field]  = "Vendor"  )[FieldValue]{0}