Formatting rows and columns

[LucyR]

Hi,

Can someone please advise how to move Total WOR figure of -593,411 beside Total WOP figure 178,172 on row 1 (currently there is zero)?  I am trying to remove the second row also.

Many thanks,

Lucy

[DeborahA · Accepted solution]

Hi @LucyR ,

Here's a workflow highlighting a possible solution to the problem you described. Hope this helps!

[Jonathan-Sherman · Accepted solution]

Hi @LucyR,

I think this solves your issue, however it's difficult to build from such a small sample of the data. I've used a multi row formula to fill in the missing value followed by a filter to remove the duplicate row and a formula to update the closing units column.

If this solves your issue please mark the answer as correct, if not let me know! I've attached the workflow for you to download if needed.

Regards,

Jonathan

[LucyR]

Thanks a mil @DeborahA!

[LucyR]

Hi Jonathan,

Thanks a mil for a quick and easy solution!

Regards,

Lucy

[Jonathan-Sherman]

No problem @LucyR, if it solves your issue please mark the answer as correct to help others find it more quickly.

Regards,

Jonathan