Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to Combine or Merge multiple, identical data tables

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.

 

 

Need Help

1 Reply

  • TaylorPBI21's avatar
    TaylorPBI21
    Resolver I
    3 years ago

    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 😊