Help with workflow completion

Marg7

I'm need help completing my workflow. I have a file which are reflecting changes occurring each month for different employee. In Nov we received all deductions for the employee then throughout the month only the changes are provided. I need to create a column for every month that would include the changes made. Here is a copy of my workflow so far. Plus an attached sample showing before and what I hope the output would be.

Test.xlsx

apathetichell

Hi!

Quick question - could you attach your workflow too? I see the excel file but only the image of the workflow - not the attachment itself.

Based upon what I'm seeing though a generate rows and a multi-row formula might be useful. I notice you have a multi-field tool on the canvas to be used - and I personally don't know I'd use one here. I'd transpose and use a multi-row formula.

One more quick thing - play around with the running total tool - that might be easier than summarize for your workflow. You'd group by customer-id/...