Use of Multi-Row Function

[atorres050]

Hi! 

I am trying to use the Multi-row function in order to make my data go from the example (1) to example (2) below. I am not exactly sure how to use this function (or if I am even trying to use the right function) in order to make the necessary changes. Thanks!

Example (1) - Initial Input

Example (2) - Final Output

[jdunkerley79 · Accepted solution]

I think a Multi Row formula with an expression like:

IIF(ToNumber([Input],1),
    IIF(ISNULL([Row-1:Header]),[Row-1:Input],[Row-1:Header]),
    NULL())

Should do what you need.

If the Input is a number then it reads the header from the line above.

I have attached a sample to get you started

[atorres050]

Thank you so much!