Multi row formula on multiple columns

Question

Hi,

I get a lot of data to analyze that comes from Excel where the user (or excel sheet developer) has merged rows together.  I can use the multi row formula tool with the statement "If row is blank, then use row-1 else use row end".  That's my pseudo-code...not Alteryx format.

In one use case I I have 7 of these such columns, and I've used 7 multi-row tools., and it looks like this...

Is there an easier way of doing this without the 7 multi-row tools.  I'm working on another dataset that has 15 of these, and am looking for a faster way out.

Thanks.

-prpatel.

multi-row formula tool usage.yxmd

Qiu · Answer

I need to study this post since it attracted many big shots. 😁

NoelCarson · Answer

An easier way could be to use formula tool create a Boolean column which is updated to '0' if blank and '1' if it has data. Then use a filter tool to remove the rows marked as '0'.

IraWatt · Answer

@patrick_digan awesome macro should be made part of Alteryx Designer by default 👏