Calc: concatenate tables

Hi there,

I have two tables, with identical structures. I need to create a third table that has all rows from both tables.

For example, let table 1 be:

   A      B
1  Name   Age
2  John   20
3  Peter  15

And table 2:

   D      E
1  Name   Age
2  Mary   23
3  Ann    21

Then I would have table 3:

John   20
Peter  15
Mary   23
Ann    21

In Google Sheets, I achieved that with a formula such as

={A2:B3;D2:B3}

But that gives a 539 error in LO.

Thanks

The inline array ={A2:B3;D2:B3} (probably you meant ={A2:B3;D2:E3}) is using ranges and not using constant strings/values and therefore is not compliant to the OASIS ODF standard, which states in Chapter 5.13 - Inline Arrays specifically:

Note: Expression authors should be aware that use of Expression other than constant Number or constant String may impair interoperability.

=> Google Sheets is addressed by this Note and that’s why you get an error 539, which is according to LibreOffice Help - Error Codes an Unsupported inline array content

For some uses, the Data - Consolidate tool can circumvent the limitation.

For most purposes it is better to keep all data of the same kind (e.g. info related to “person”) in a single table and use extraction tools (filters, lookup, etc.) to produce the subsets you need. Less intuitive, but more reliable.