Row Data Arrangement

[EvansM]

Hello community,  

I have a sample data attached to this message. Included is my Input data and the output data. Could someone give me the formula to re-arrange this data and what steps i should use to get exactly like the output data.  

Note:  In the spreadsheet, under the Event_type column, an 'Attach' and 'Detach' completes one move.  Therefore, sometimes there could be more and Attach followed by another Attach without a Detach hence we need to show that Attach as a dash(-).   This also applies to Detaches that follow one another.  Please see this in the document.

[JessieC · Accepted solution]

@EvansM -

Here is what I came up with - 

Attached is the workflow.

[EvansM · Accepted solution]

I am having a problem with this formula here

[JessieC · Accepted solution]

I'm just selecting all the text fields that need to replace nulls with "-"

[EvansM]

Thanks  a lot