The second column “WO” values mark how the rows of the first column should be joined in a single new row, example: rows 201, 202, 203 and 204 must end up being a single row, and repeat the same process every time a WO starts.
Thank you in advance for all your suggestions. Every bit of help is truly appreciated.
This is tricky in its current form since the RM Mark column has a generic value. I recommend amending it in such a way to create unique groups.
Below is one way:
Make the RM Mark unique by concatenating the RowIndex when a value is found. You can do this via Java Snippet or Column Expression. In CE, you can use:
Tip: try to include your workflow or attach the source in cases like this. It makes peoples lives a lot easier as it avoids having the re-type your data structure.
This is so great. I spend hours working on something and then you hit the wall and get stuck, with no new ideas and someone comes with the most amazing solution. Thank you for making it look so easy, and thank you for the information you shared. This worked. Thank you again.