formula to generate a string

Hi Special-K,

It's not an awfull lot of data. A little over 1800 records, but enough to want to have an outomated solution .
Unfortunately I don't have Textjoin at the moment, but I will have a look into this.

Thank you.

Awesome. I will give that a try tomorrow.
Judging from the reddit link, It say textjoin should be available in office 2016. I can't remember having seen it earlier when I was at work.
I will have a look at it tomorrow.

Thank you.

TEXTJOIN is only available if you have an Office 365 subscription.

You can use Power Query for this.

Although this isn't the exact result that you're after, I suspect this may be helpful if not ideal.

1) Highlight the data > Data > From Table > OK
2) Group By > Group > New column name: Temp > Operation: All Rows > OK
3) Add Column > Custom Column > =Table.Column([Temp],"Number") > OK
4) Delete the Temp column
5) Click on the button next to the Custom header > Extract Values > Custom: | > OK
6) Home > Close & Load

See attachment.

Hi,

Awesome. This is basically what I am looking for. At least it beats going through all the records by hand.
Thank you so much.

Kind regards,
lightframe109

You're welcome. Happy to help.

The cool part about Power Query is that once it is built, all that you have to do if you get more data in the future is add it to the bottom of the blue table then refresh the green table.