How to fill null values with data in a before and after row

Hi all, I have a problem where I want to fill the null value with data from before and after the row. I tried to use a multi-row formula, but it can only be before or after. Is there any solution for this?

Input:

Screenshot 2025-03-05 104719.png

Desirable Output:

Screenshot 2025-03-05 104759.png

Transformation

Preparation

Accepted answers

flying008

Hi, @NadiaMazlan25

IF IsEmpty([Name]) && [Row-2:Name] = [Row-1:Name] THEN [Row-1:Name]
ELSEIF IsEmpty([Name]) && !IsEmpty([Row-1:Name]) && !IsEmpty([Row+1:Name]) THEN [Row+1:Name]
ELSE [Name] 
ENDIF

All comments

flying008

Hi, @NadiaMazlan25

Update Existing Field with:

IF IsEmpty([Name]) && [Row-2:Name] = [Row-1:Name] THEN [Row-1:Name]
ELSEIF IsEmpty([Name]) && !IsEmpty([Row-1:Name]) && !IsEmpty([Row+1:Name]) THEN [Row+1:Name]
ELSE [Name] 
ENDIF

录制_2025_03_05_11_21_23_740.gif

NadiaMazlan25

Hi @flying008

I tried the formula, but I noticed the value for 'Company D' is replaced by 'Company E'

flying008

Hi, @NadiaMazlan25

IF IsEmpty([Name]) && [Row-2:Name] = [Row-1:Name] THEN [Row-1:Name]
ELSEIF IsEmpty([Name]) && !IsEmpty([Row-1:Name]) && !IsEmpty([Row+1:Name]) THEN [Row+1:Name]
ELSE [Name] 
ENDIF

NadiaMazlan25

Hi @flying008

Thank you. It works perfectly. For an additional question, what if there are 2 null columns above it? how to solve it?

Screenshot 2025-03-05 120716.png

flying008

Hi, @NadiaMazlan25

Well , there is a full dynamic resolution for you , if you get your want, please mark it as a solution and give a like for more share.

Spoiler

Replace(REGEX_Replace([Name], '((?<=,)(?:<,)+([[:alpha:]\s]+),(?:<,)+)', '$2$1'), '<', '')

录制_2025_03_05_13_23_32_835.gif

Input		Output
Name	Address	Name	Address
Company B	Address 2	Company B	Address 2
	Address 2	Company C	Address 2
	Address 3	Company C	Address 3
Company C	Address 4	Company C	Address 4
	Address 4	Company C	Address 4
	Address 5	Company C	Address 5
Company D	Address 6	Company D	Address 6
	Address 7	Company E	Address 7
	Address 7	Company E	Address 7
	Address 7	Company E	Address 7
Company E	Address 7	Company E	Address 7
	Address 7	Company E	Address 7
	Address 7	Company E	Address 7
	Address 7	Company E	Address 7
Company F	Address 7	Company F	Address 7

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703