Power query M transform list of list to text

Hello,

I have a list of lists created using TabletoRows;

and I want to combine each list using Text.Combine, but some of the values are dates and numbers;

I've tried using

Please Login or Register  to view this content.

but this gives the message convert type list to text, I have got what I wanted by changing the data type in the drip down before
and have included this in the workbook attached, but is it possible to change the type uisng list.transform and another funciton?


Richard.

try

Please Login or Register  to view this content.

Thanks,

RD

Thanks, I usually have multiple listtransforms where one would do.

Will try these out.

Richard.

Thanks for both answers,
Will mark up as solved.

RD

You are welcome