Power Query using Table.TranformColumns

Hi,

I have a query, and it's working but I'd like to incorporate the 'expand' end part into the code,
but I need to use Text.Combine and first transform the values into text from numbers and I can't figure out where to place it.


This is the code ;

Please Login or Register  to view this content.

And I'd like to nest the last part 'extract' into it rather than just using expand columns. I've then used this as a funtion to work on all the groups.
I've attached a workbook show stages and finished example.

Richard

I've found that this works;

=

Please Login or Register  to view this content.

Finally got things in the right order.

Richad.