In the data I have fields "ItemName" and "ID". I need to group rows by "ItemName" and somehow make a "human readable" range of sequential numbers in "ID". I was attempting to do it using Power Query with no luck. What tools or HowTo's do I need to know to get something like in the example image below.

[![enter image description here](https://i.stack.imgur.com/ZnDnQ.png)](https://i.stack.imgur.com/ZnDnQ.png)