Merge dynamic columns' name

Hi,

How can I choose all the column start with a specific text or any dynamic selection in the Merge column function?
here is an example:


--> choose all column start with "A", and merge them to have result: ccb

Thanks,
T

Hi shuyin,

You can use a pattern like this (Text.Combine can be replaced with another function if you are doing something different from concatenating text):