Forum Discussion
Helper IITable.CombineColumns
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.
Most Valuable ProfessionalIn 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]
Dom87326Your 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
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.