Fill nulls across rows using data in row +1 without using 15 million multi row tools.

I want to fill the nulls across multiple fields using the data found in row+1 without using 12 or more multi-row formulas. Is this possible. Below is an example of how the data appears with the Null values not filled.

Note: The rows will share LN, Level of Detail and Value to start.

Year	LN	Acct	Acct Title	Bike	Level of Detail	Value
2020	999	[Null]	[Null]	[Null]	Comment	100
2020	999	9001	Cervelo	S-3	Line	100
2020	999	[Null]	[Null]	[Null]	Comment	35456
2020	999	8003	Specialized	Roubaix Pro	Line	35456

Help

Expression

Accepted answers

philipmannering

Something like this?

All comments

philipmannering

Something like this?

Thank you. I am slowly learning that RecordID can be your best friend.

@hellyars
No chance to do the field test

1113-hellyars.yxmd

@Qiu Cool. Check out the solution above. It simple and elegant using Transpose + MultiRow+ CrossTab.

@Qiu I was being dramatic when I said "15 million multi row tools". I was trying to avoid using 10 or more multi tool rows.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703