Question on Filling Null Values

[ghtill]

Apologies if this type of question has already been posted I could not find it. I am trying to fill null values based on an ID. So when ID is the same as an already filled in Award it will fill in the nulls with this value.

ID	Award
20156	W&P
20653	BofA
20653	[null]
20896	TRIF
20896	[null]
20896	[null]

ID	Award
20156	W&P
20653	BofA
20653	BofA
20896	TRIF
20896	TRIF
20896	TRIF

[IraWatt · Accepted solution]

Hey @ghtill,

There are a few ways to do this. One way is to get only the Awards which are not null then for each ID get the first row and join that back onto the original data:

Will an ID every have multiple Awards?

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[ChrisTX · Accepted solution]

Try the multi-row formula tool

Here's another option:

Chris

[ghtill]

Thank you! @ChrisTX and @IraWatt 

[IraWatt]

No worries @ghtill, Glad to help 😄