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

[hellyars]

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

[PhilipMannering · Accepted solution]

Hey @hellyars 

Something like this?

[hellyars]

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

[PhilipMannering]

Definitely.

And transposing > doing something > crosstabbing back is a common scenario when you want to do the same thing across multiple columns (and can't use the Multifield).

[Qiu]

@hellyars 
No chance to do the field test

[hellyars]

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

[Qiu]

@hellyars 
My understanding was to avoid using MultiRow due to huge data.

[hellyars]

@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. 

[Qiu]

@hellyars 
haha, guess I am being too serious.

Anyway, good your problem gets solved.