Sequential number output using dash

[andrewplaice]

Hi all,

It's been a few months since I posted so I must be learning something!  I am, however, stumped on this.  I have table data that I concatenated to combine rows, but would like to make the concatenated data even more concise.  Rather than listing sequential data, I'd like to use a dash, when appropriate, but I am not sure the best way to approach this.  My data currently looks like the Delay Period data, but would like it to look like Revised Delay Period data.

Appreciate your help as always!

Delay Period	Revised Delay Period
1, 2	1-2
5, 6, 7, 10, 11, 12, 15, 16, 17, 20, 21, 22	5-7, 10-12, 15-17, 20-22
5, 10	5, 10
6, 66, 126, 186, 246	6, 66, 126, 186, 246
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12	1-12

[OllieClarke · Accepted solution]

@andrewplaice That was a fun challenge! Here's what I came up with:

[Greg_Murray · Accepted solution]

@andrewplaice 

here you go! 

[andrewplaice]

That's awesome!  Thanks!