Multi Row Formula issue

Hello everyone,

I try to use the Multirow formula in my process but i think i don't use it correctly, i can't find how to get the result i want..

This is the kind of data i want to process

And this is the result i want to have:

AS you can see in my workflow the field takes the previous field each time in the column ACCOUNT... i only need the Account number

Can you help me about that please ?

Thank's a lot in advance

multirow.xlsx

Multirow.yxmd

Workflow

Accepted answers

BenMoss

And here is how I would actually approach the problem by amending the multi-row formula tool entirely.

Ben

Multirow.yxmd

All comments

BenMoss

Is the account always numeric, if so we can just use a regex statement at the end of your current workflow to pull this out.

If not I would propose another method entirely?

Example attached of the regex method.

Multirow.yxmd

BenMoss

And here is how I would actually approach the problem by amending the multi-row formula tool entirely.

Ben

Multirow.yxmd

Cc_1

Please, I need solution to the problem attached. I would appreciate whatever input you can provide. I am trying to attain the part of the workbook that is highlighted yellow while the area to your left not highlighted is the current state. Thanks

Sample File.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703