[Solved] Merge two (2 axis) spreadsheets into one

[alienrobotghost]

See attached... (hopefully I described it in a way that makes sense)

[JohnSUN-Pensioner]

Welcome to the forum!
You got a very beautiful screenshot. I even wanted to solve this problem for you. But when I thought that I would have to create these two tables for testing, I became lazy. It's so boring to manually create data if you know that this data already exists somewhere. If instead of a screenshot you give a sample of the data in the form of a spreadsheet, then (perhaps!) it is possible to avoid agonizing amount of work

[alienrobotghost]

Here is the actual file... I want to combine the contents of sheet 2, into sheet 1...

[JohnSUN-Pensioner]

OK, we can do something about it! I did not understand the purpose of the yellow background of some columns and rows, so I did not transfer them to Sheet3

Update In fact, it is very simple. Supplement your original table with new values, sort by the first column, transpose the table, sort again and transpose again.
All this takes no more than a minute, details on YouTube

[alienrobotghost]

You, my friend, are FREAKING AWESOME!!!

Thank you for this!!!

[MrProgrammer]

The steps below would do what you've asked with any version of OpenOffice, LibreOffice, NeoOffice, etc. This is similar to JohnSUN-Pensioner's method but doesn't need the transpose steps. It merges the two spreadsheets whether or not the second one is empty.

Step 1
Copy/paste three ranges from the second spreadsheet to the first.

Step 2
Sort the range shown (excludes the first row)
Select only the columns with your data, not all of them
Data → Sort → Options → Uncheck Range contains column labels → Direction = Top to Bottom
Sort Criteria → Sort by → Column A → Ascending → OK
The Step 2 image below shows the result after performing these steps

Step 3
Sort the range shown (excludes the first column)
Select only the rows with your data, not all of them; asking Calc to sort a million rows will be very, very show
Data → Sort → Options → Uncheck Range contains row labels → Direction = Left to Right
Sort Criteria → Sort by → Row 1 → Ascending → OK
The Step 3 image below shows the result after performing these steps

[JohnSUN-Pensioner]

Oh yes, Mr. Programmer! I completely forgot that we can sort rows, not just columns! Of course, here two transpositions are completely unnecessary, just set the green option at the right time.

(I’m not sure that "Unchek" used in the description of the sequence of actions is a correct word. It seemed to me that the "Turn On" is more correct. Or I missed again?)

[alienrobotghost]

For the instruction:

"Sort Criteria → Sort by → Column A → Ascending → OK"

"Column A" is not an option... there is an option for "undefined" or any of the coordinates for the columns i've selected (which the previous instruction says to only select the columns that contain the data I want to merge)

What am I missing here?

[JohnSUN-Pensioner]

Perhaps if you write at least something to cell A1 (for example, the \ character), the sorting modes become a little clearer - you can see "Сolumn A" or "\" depending on the state of the "Range contains row/column labels" switch

[alienrobotghost]

I'm sorry, I was not following the instructions correctly... but I figured it out now... thanks for your help