Can a union table merge another table?

[Anonymous]

I can't find a way to do that. First I have to load those tables, but my union table didn't show up in my pane.

[TomMartens]

Hey @Anonymous ,

the simple answer - yes you can union two or more tables using Power Query, in Power Query this operation is called Append, then you can Merge a different table.

But without any information what you are exactly trying to do, I can not provide more guidance.

Consider creating sample data, e.g., one Excel file with multiple sheets, where each sheet represents one of the tables. Upload the xlxs to OneDrive, Google Drive, or Dropbox and share the link.

Desribe the expecte result based on the sample data you provide. Ideally one sheet in the Excel file represents the expected result. Be explicit about rules, e.g., how the tables are merged.

Regards,

Tom

[Anonymous]

Hi, Tom,

Thank you very much for your reply. But, how do we start it?

At first, we choose Home >>Transform data >>Transform data, at this time, my union table is invisible. I choose the other table first, but in the selection area, I can't find my union table.