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.
-
Click on the top left corner of a secondary table, this will select all rows and columns of that table.
-
Copy all those selected rows (press Control-C).
-
Click on the master table end, in the first field (the row you use to input new data).
-
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.
-
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