Hi,
I want to make a work flow bases on below data
| Grup | acc | amount | ststem |
| 499111 | 301111 | 140325.1 | CUS |
| 499111 | 501112 | 140325.1 | WIN |
| 499411 | 501411 | 7409.26 | CUS |
| 499411 | 501407 | 7409.26 | WIN |
| 499411 | 501411 | 7409.26 | CUS |
| 499411 | 501407 | 7409.26 | WIN |
| 499899 | 301899 | 13.69 | CUS |
| 499899 | 501999 | 13.69 | WIN |
| 499958 | 301958 | 264483.5 | CUS |
| 499958 | 301958 | 264483.5 | CUS |
| 499958 | 301970 | 264483.5 | WIN |
| 499958 | 301970 | 264483.5 | WIN |
Below are the conditions
1) account number corresponding to Win should come first and corresponding CUS account to come second
and corresponding amount
eg
| | | |
| account1 | account2 | amount |
| 501112 | 301111 | 140325.1 |
| 501411 | 501407 | 7409.26 |
since amount of both system are same i want one column for amount
Above example i have total 12 entries so i want to make 6 raw
2) goup account of Win & cus should match
