Help - Data with initial event and final event on different rows

[David-teryx]

Hello, I have this example has initial event types like "Error" or "Alert" with final event types like "Error Fixed" or "Alert Fixed".  The Data have initial event and final event on different rows and always are in that sequence. For all Error event or Alert event there is a Fixed event before we can see another Error event.

I am trying to get the Date and the Time from the final events and insert that value on new columns, so I can have the inital event Date/Time and Final Date/Time on the same row to read the event in one single row.

There is no other data available to identify relation between initial and final event.

I appreciate any help, thank you.

RecordID	Description	Type	Date	Time	Error Fixed or Alert Fixed DATE	Error Fixed or Alert Fixed TIME
1	Print Open	Error Fixed	10/2/2023	14:02
2	Print Open	Error	10/2/2023	14:02
3	Print Open	Error Fixed	10/2/2023	14:03
4	Print Paused	Alert Fixed	10/2/2023	14:03
5	Paper Out	Error	10/2/2023	14:04
6	Printer Paused	Alert	10/2/2023	14:07
7	Print Open	Error	10/2/2023	14:08
8	Paper Out	Error Fixed	10/2/2023	14:09
9	Print Open	Error Fixed	10/2/2023	14:11
10	Print Paused	Alert Fixed	10/2/2023	14:12
11	Tape Out	Error	10/3/2023	18:03
12	Tape Out	Error Fixed	10/3/2023	18:03

[David-teryx]

Hello @flying008  Yes it is the result I want.  I already tried to guess the way you configure the tools and got no luck to replicate what you did.
The Gif you sent me is not clear to my understanding of this. If you are unable to upload the workflow file, Please let me know the way you configure the tools: Multi-Row Formula, Multi-Field Formula,  Formula and Find Replace tools.

I appreciate your help on this.