Share
Report
68There 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?
Categories:
I have the same question (0)
All responses (
Answers (
