Hello,
Trying to see how I can use Multi Row Formula or any other method to build a workflow that has Start and Stop values in single row for event called 'Stop' and I am looking to create new column and populate with Start and Stop values in single column. However the events are not always continuous,for example, start is not always followed by stop event, sometimes it is followed by another start event and stop can be followed by another stop event. Below in an example snippet of the data set and the new column is what I was trying to get to. Any help is much appreciated.
| ID | Event | Event Id | Date | Start Value | End Value | New Value |
| 200 | Start | 1 | 5/8/2019 10:44:16 AM | Null | Null | 9 |
| 200 | Stop | 2 | 5/8/2019 11:05:50 AM | 9 | 10 | 10 |
| 200 | Start | 1 | 5/8/2019 12:30:48 PM | Null | Null | 22 |
| 200 | Start | 1 | 5/8/2019 12:59:35 PM | Null | Null | 44 |
| 200 | Stop | 2 | 5/8/2019 1:03:28 PM | 22 | 33 | 33 |
| 200 | Stop | 2 | 5/8/2019 1:31:56 PM | 44 | 55 | 55 |
I've attached my workflow and sample example output in it as well.
Please let me know if you need more information or have any questions.
Thank you in advance!
