How to Combine or Merge multiple, identical data tables

[Anonymous]

I use several different data tables as data sources (Out of my control) and want to somehow merge, combine, or join all of the data into a single table to enable ease of use and visualization. All of the tables have the exact same data fields (columns). Each table is sourced inside a seperate Excel spreadsheet that is directly accessed by the operator of the data (The person entering the raw data). Any help is greatly appreciated.

[TaylorPBI21]

Hi @Anonymous ,

You could go into transform data and append queries either to a selected table or as a new table. Select "append queries" for your selected table to append the other tables to an existing table or select append queries as new to create a new table...

Many Thanks,

Taylor 😊