Sum the values to the next row and leave one row blank

[dineshbabu2811]

Hello Community,

Kindly help the below logics to be implemented. I have to sum the amounts based on the account and paste those values to the next line and leave one row blank to separate the accounts. 

No of rows will be dynamic, its not fixed.

Input

Output

[binuacs · Accepted solution]

@dineshbabu2811 One way of doing this with the bath macro

[dineshbabu2811]

Thanks @binuacs Awesome, output is as expected.

But initially we have different data structure and enriching to this format(mentioned as input) and need the output format with spaces and values as you gave.

could you please modify the workflow accordingly and help us.

[binuacs · Accepted solution]

@dineshbabu2811 Sorry I am not following your requirements. Can you explain a little bit more?

[dineshbabu2811]

I have done few changes and updated workflow. Now output is perfect. Thanks @binuacs