Kindly help me to overcome this functionality. I have data in the below format, all the steps is going to be performed one by one.
|Script Name||Step Number||Step Team||Step Execution|
|Script A||Step 1||A||Passed|
|Script A||Step 2||A||Passed|
|Script A||Step 3||C||Passed|
|Script A||Step 4||C||Passed|
|Script A||Step 5||C||In Progress|
|Script A||Step 6||A||Not Started|
|Script A||Step 7||H||Not Started|
|Script A||Step 8||H||Not Started|
You will see that Script A is right now in Step 5(i.e In Progress), all the above test are Passed.
|Script A||Result||Steps Preformed Continiously|
The numbers is the Count of steps a team continously performing. We would like to show that A has finished and now C is currently doing their steps as Step 3 & Step 4 is passed and Step 5 is in progress we need to group C(Step 3-Step5) and show as In Progress.
And the next in line is again A with 1 step and H with 2 steps(again as H is doind 2 step we gonna group them and show as H not atarted 2 items).