Grouping, Transforming, and Describing

[MsBindy]

I think I am overthinking some data manipulation I'm trying to accomplish.

I have a list of Change Orders on a project, each with a Change Order number and a standard description.

I would like to turn it into a table that groups the change order by that standard description, and then lists the change orders.  However, I don't just want to concatenate the change orders.  I want them to be listed a little differently if they are a contiguous range.

I've put some sample start data and the desired results in the attached workflow.

[MsBindy]

I think I am overthinking some data manipulation I'm trying to accomplish.

I have a list of Change Orders on a project, each with a Change Order number and a standard description.

I would like to turn it into a table that groups the change order by that standard description, and then lists the change orders.  However, I don't just want to concatenate the change orders.  I want them to be listed a little differently if they are a contiguous range.

I've put some sample start data and the desired results in the attached workflow.

[binu_acs · Accepted solution]

@MsBindy one way of doing this

[Raj · Accepted solution]

@MsBindy 
find the workflow attached
mark done if solved.

[MsBindy]

Thank you both!  These are actually quite similar.