We have a requirement where we need to group all similar stages in one ie if there are four stages A,B,C and D .
For Stage A if there are four records then all the four columns of Stage “A” should be merged in one , and other fields should be after this.
Something like this :
| Name | Count | Open | Signal | Amount | Status | |
| A | ABC Pipeline | 23 | TRUE | Red | 45 | Closed |
| DFC Pipeline | 45 | FALSE | Blue | 43 | New | |
| New Pipeline | 67 | FALSE | Green | 34 | Ongoing | |
| CDF Pipeline | 34 | FALSE | Yellow | 23 | Blocked | |
| B | ABC Pipeline1 | 23 | TRUE | Red | 45 | Closed |
| DFC Pipeline2 | 45 | FALSE | Blue | 43 | New | |
| New Pipeline3 | 67 | FALSE | Green | 34 | Ongoing | |
| CDF Pipeline4 | 34 | FALSE | Yellow | 23 | Blocked | |
| New Pipeline5 | 67 | FALSE | Green | 34 | Ongoing | |
| C | ABC Pipeline11 | 23 | TRUE | Red | 45 | Closed |
| DFC Pipeline21 | 45 | FALSE | Blue | 43 | New | |
| New Pipeline111 | 67 | FALSE | Green | 34 | Ongoing | |
| CDF Pipeline41 | 34 | FALSE | Yellow | 23 | Blocked | |
| New Pipeline654 | 67 | FALSE | Green | 34 | Ongoing | |
| New Pipeline551 | 67 | FALSE | Green | 34 | Ongoing |
