Multi Row Function on 1000 Columns

Hi All,

I am trying to use the multi row function like I would in Excel. For all columns I need to bring down the the first row of data to other other rows based on column A "Record ID".

I have attached the file. Please let me know how this can be done!

Best,

Jackie

Custom Tools

Macros

Batch Macro

Help

Expression

Iterative Macro

Accepted answers

AbhilashR

Hi @Jswartz5, it doesnt work due to the empty cells being nulls in my case while they are blank in yours. Modify the logic inside the multi-row formula tool to this and it should work:

IF ISEMPTY([Value]) THEN [Row-1:OUTPUT]
ELSE [Value]
ENDIF

I used ISEMPTY instead of ISNULL function.

All comments

ChiN

Hi @Jswartz5 ,

Can you provide the results with dummy data to show the output you want to achieve?

Thanks!

Jswartz5

@ChiN Here is an example of what I would want the output to be, I only did the first 5 "companies" since it would have too long to the whole file.

AbhilashR

Hi @Jswartz5, attached is one approach that helps fullfill the multi-row calculation across multiple columns. Let us know if this isn't that you are looking for.

sample.yxmd

Jswartz5

Is there a reason it wouldn't work with my current WF?

I have attached my WF.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703