Merge multiple tables

Question

I have lots of sheets describing different kind of expenses and gains of my small company, and I find no easy way to merge my tables like in this example I made:

I want the last table to be auto filled with the lines of the others tables when I update them, so I can foresee the expenses and gain in time (by ordering the green table automatically by date ascending).

By now the only temp solution I found is to copy references to the other tables lines (yellow and blue) in the merging table (green) in advance.

Pivot tables do not permit to achieve this kind of gathering on several tables.

Why the excel tag? If you were using Excel then there may be A VBA solution. Excel 2013+ may allow a PowerPivot answer. Google Sheets don't implement either of those. — Mark Fitzgerald
– Mark Fitzgerald, Commented Dec 28, 2016 at 14:47
ok well, i am looking for a solution who would work in any calc software, but my preferences goes to libreoffice/openoffice/google sheets ;) i tagged excel to look for similar solutions in these — Ty Kayn
– Ty Kayn, Commented Dec 28, 2016 at 14:50

Karl_S · Accepted Answer · 2016-12-28 15:03:28Z

11

Use this Query formula in cell I2:

=QUERY({A2:C; E2:G}, "select * where Col1 is not null", 1)

To also order them by Date, add the order by:

=QUERY({A2:C; E2:G}, "select * where Col1 is not null order by Col1", 1)

answered Dec 28, 2016 at 15:03

Karl_S

3,5922 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ty Kayn Over a year ago

we are going somewhere with this, but i get a syntax error. i finally arrived to get something good with this QUERY function. like so: =QUERY({E2:G;A2:C}; "select * where Col1 is not null") thanhks!

Collectives™ on Stack Overflow

Merge multiple tables

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related