Combine Multiple Tables into One

I have a three tables each having the same no. of columns with same column type. And the data is added in these three tables manually.

I need to combine all these three tables data in a master table which will have same no. of columns and same column type. Is there a way to combine (not as a summary) these three tables into one master table?

Hello,

I have a similar problem, and solved it by just cutting and pasting the entire secondary tables into the master one.

  1. Click on the top left corner of a secondary table, this will select all rows and columns of that table.

  2. Copy all those selected rows (press Control-C).

  3. Click on the master table end, in the first field (the row you use to input new data).

  4. Press Control-V, this copies all selected rows of the secondary table into the master one, as the columns are the same in the secondary table and the master one.

  5. Do steps 1 to 4 for the other 2 of your secondary tables.

This should get you the result of the 3 secondary tables regrouped into a single master one.

This solution is fine if you just have to do this from time to time (it is exactly how you would do it in a “normal” spreadsheet).

If this becomes tedious manually because you have to do it very often, then get someone to program a short Python script to do this automatically.

Hope this helps.
Michel