Need to perform several multi-row formulas, but the number will be dynamic based on data

Mtvbqb

The number of columns in my data will vary dynamically.

If the next row of data is empty, I want to copy it from the above row. The formula for my multi-row formula looks like this:

IF IsNull([F11]) THEN [Row-1:F11] ELSE [F11] ENDIF

Where F11 is an example column. The issue is that I may need to do this, 4, 6, or 20 times on a file depending on the data included. Is there a way I can systematically check each column and perform the multi-row formula?

grossal

I think I got what you want, but it looks a bit odd, so does the sample data.

What happens:

1) I Filter out the Total Record rows in the end

2) Shift columns to rows (Transpose)

3) Sort them

4) Multi-Row Formula to handle your replacements 

5) Cross Tab to bring them back into shape

6) Sort again to get back to the original order

7) Auto Field to adjust the Field Types

I hope I got what you want but I am not sure, because everything looks a bit odd. Workflow attached.

Best

Alex

2020-03-29-mtvbqb.yxmd