It is a very common situation when different pieces of data are dispersed across many worksheets and workbooks. Fortunately, Excel provides a few tools to combine data from multiple tables into one, and this tutorial will teach you how to use these tools most effectively. Continue reading
Comments on: How to merge two or more tables in Excel
by Svetlana Cheusheva, updated on
Table of contents
Comments page 2. Total comments: 38
~ Amazing Add-in! Thank you very much for still developing this very useful and resourceful tool, Keep it up! =)
Hi,
I have a question. I just bought the add-in but I am unable to figure out what I want to do.
I have excel sheets for each projects I am working on.
Sheet Project A
Table1, Columns: Task, Assigned to, Start date, Due date, Status
Sheet Project B
Table2, Columns: Task, Assigned to, Start date, Due date, Status
Sheet Project C
Table3, Columns: Task, Assigned to, Start date, Due date, Status
And now I want to view all the tasks created in these three tables on 1 single table.
Could you tell me how to do it?
Best regards,
Baatarbat
Hi Svetlana,
I read your posts with interest. I hope you can help me with my query:
I have three one-column tables and wish to create a new 3-column table combining them in the following way:
TableA:
Item_A1
Item_A2
Item_A3
TableB:
Item_B1
Item_B2
TableC:
Item_C1
Item_C2
Item_C3
Item_C4
NewTable:
Item_A1 Item_B1 Item_C1
Item_A1 Item_B1 Item_C2
Item_A1 Item_B1 Item_C3
Item_A1 Item_B1 Item_C4
Item_A1 Item_B2 Item_C1
Item_A1 Item_B2 Item_C2
Item_A1 Item_B2 Item_C3
Item_A1 Item_B2 Item_C4
Item_A2 Item_B1 Item_C1
Item_A2 Item_B1 Item_C2
Item_A2 Item_B1 Item_C3
Item_A2 Item_B1 Item_C4
Item_A2 Item_B2 Item_C1
Item_A2 Item_B2 Item_C2
Item_A2 Item_B2 Item_C3
Item_A2 Item_B2 Item_C4
Item_A3 Item_B1 Item_C1
Item_A3 Item_B1 Item_C2
Item_A3 Item_B1 Item_C3
Item_A3 Item_B1 Item_C4
Item_A3 Item_B2 Item_C1
Item_A3 Item_B2 Item_C2
Item_A3 Item_B2 Item_C3
Item_A3 Item_B2 Item_C4
Please note that the number of rows in each of the three tables are dynamic and populated from SQL server queries. So, a copy/paste method is not practical. I think Power Query is the best approach but I don't how.
I need to publish/send reports based on the new table. So, if your "Ultimate Suite" provides a solution for me, does it need to be installed on the remote computers too?
Many thanks for your help.
Abbas
Hi Abbas did you figure out how to do this?
Hi Abbas,
I regret to tell you that none of our tools can help with this task. I am not sure that even Power Query can do that, at least I don't know a way. Sorry :(