There is an online excel table as below structure:
InvNo | ProID | Amt |
001 | P01 | 100 |
001 | P02 | 200 |
001 | P02 | 100 |
002 | P02 | 100 |
002 | P03 | 150 |
I want to add row with same InvNo & same ProID and sum the Amt as below structure:
InvNo | ProID | Amt |
001 | P01 | 100 |
Total | 100 | |
| ||
001 | P02 | 200 |
001 | P02 | 100 |
Total | 300 | |
| ||
002 | P02 | 100 |
Total | 100 | |
| ||
002 | P03 | 150 |
Total | 150 |
Since Office Scripts is not available for me, is it able to achieve this with power automate without premium access?