Dynamic reorder of columns in PowerQuery

[afgi]

hi,

I would like to reorder my PQ columns in Excel with no hard coding of all names. I have 3 columns which I would like to move to 3 first positions in the table. I can hard code the names of those, but all the other columns are dynamic and I cannot hard code those. Any idea of how to fix that problem?

1.png

[AliGW]

In PQ, select those columns and then right-click - move to start (or similar wording).

If you want more specific help, attach a workbook, not an image.

[afgi]

In PQ, select those columns and then right-click - move to start (or similar wording).

If you want more specific help, attach a workbook, not an image.

hi,

when you make this step, then you hard code all the column names and this is what I want to avoid. I can keep only 3 column names in the code, the rest has to be dynamic.

Please Login or Register  to view this content.

[afgi]

hi,

and the file attached

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[afgi]

works like a charm thanks