Group in Alteryx - bring down the previous value untill it finds another value

Cesc

Hi, I have a document with the financial statements of a company. I am attaching an example of it without confidential data.

I have the column A, that i need to drop down.

Explaining myself better. In the A2, C2, D2 and E2, there is the "title" of the row. And we need to copy the number for all the following rows untill we find the number 2 in A12.

From this:

To this:

Any tips?

Thank you so much!!!

Book1.xlsx

MarqueeCrew

@Cesc ,

The quick cure to this is the MULTI-ROW formula

IIF(IsEmpty([Field1]),[Row-1:Field1],[Field1])

If the current row value for "Field1" is empty, then take the value above it.  Otherwise, take the given current value for "Field1".   The trouble is that you need to repeat this for each field that you have in your data that you want to process.

I create and share macros that solve problems that are "generic" in nature and should be solved easily for users.  I'll see where I have time to play with this as a "BATCH" macro.  The user would identify the desired fields that they would like to COPY DOWN from and then update their incoming data.  Thanks for the idea.

Cheers,

Mark