Question on Filling Null Values

Question

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.

IDAward20156W&P20653BofA20653[null]20896TRIF20896[null]20896[null]

IDAward20156W&P20653BofA20653BofA20896TRIF20896TRIF20896TRIF

IraWatt · Accepted Answer

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 Answer

Try the multi-row formula tool

Here's another option:

Chris