If value in column b is duplicated, and one row shows value in column c, duplicate for all

[JoshuaElphee]

I have a workbook where the value in column B may be duplicated, however column C may be showing a value in only one row.  I need to duplicate this in all rows that have the same value in column B?

In the example below, prog is not filled out, however since Proj has the value somewhere in the workbook, the prog should be included in all rows with that proj

ID	Proj	Prog	*requested output
a	abc-123		abc
b	abc-123	abc	abc
c	bde-456	bde	bde
d	abc-123		abc

[Qiu]

@JoshuaElphee 
I think I just answered your another similar question, maybe you can check that.

[gawa]

hi @JoshuaElphee 

To do that, find Prog value for each Proj by Summarize tool+Filter tool, and append it to original data by JOIN tool.

I assumed that all Proj always have only one Prog value somewhere, and the rest of rows have NULL or EMPTY.