Multi Row Function on 1000 Columns

[Jswartz5]

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

[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.

[Jswartz5]

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

I have attached my WF. 

[AbhilashR · Accepted solution]

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.

[grazitti_sapna]

HI @Jswartz5 , try this.