Reorder columns by listing only those column names to be moved

[Anonymous]

I have a Power Query that imports data from JSON URLs which I am constantly switching so that many of the headers change

But All JSON data share some headers

{"Id", "Label", "Email", "Project Name", "Type", "Segment", "Description", "First Name", "Last Name", "Email 2", "Email 3", "Initial Date", "Last Date", "Image"}

I want to move these to the "front" of the table

I tried this

#"Appended Query" = Table.Combine({#"Changed Type", addMissingEmails}),
#"Reordered Columns" = Table.ReorderColumns(#"Appended Query",{"Id", "Label", "Email", "Project Name", "Type", "Segment", "Tags", "Description", "First Name", "Last Name", "Email 2", "Email 3", "Initial Date", "Last Date", "Master ID", "sumApp Link", "Image"},MissingField.Ignore),

 But it does NOT move ALL columns listed to the front of the table

Is there a way to do this?

Thank you in advance

[ronrsnfld · Accepted solution]

Something like:

firstColumns = {"Id", "Label", "Email", "Project Name", "Type", "Segment", "Description", "First Name", "Last Name", "Email 2", "Email 3", "Initial Date", "Last Date", "Image"},

#"Reordered Columns" = Table.ReorderColumns(#"Appended Query",firstColumns & List.RemoveMatchingItems(Table.ColumnNames(#"Appended Query"),firstColumns))

[Anonymous]

Thank you. That sorted it!