Table.CombineColumns

[Dom87326]

Hello Experts,

I have the following problem of merging columns.

I'm using Combiner.CombineTextByDelimiter("", QuoteStyle.None), but would likte to see Merged column only with Column B values:

Does anyone have any solution for that?

Thanks in advance! 

[Vijay_A_Verma]

In this case, you don't need to use Merge operation. You are just retrieving the value of column B. You should use a Custom column named Merged with following formula

=[Column B]

[Dom87326]

Your right, is it possible to add custom column right after column B? By default they are added at the end of table. I have survey response data, and the layout is important for unpivot transofrmation. 

[Vijay_A_Verma · Accepted solution]

PQ will always add a custom column at the end. Only option is to reorder the column after the custom column is added. Hence, you will have to select the custom column and drag to an appropriate position. Though you can always merge addition and reordering into one single step.