How to convert horizontal table to vertical google sheets?

Question

Spreadsheets

There is a table like
column1 | column2 | column3 | column4
number1 | text1 | number2 | text2
number3 | text3 | number4 | text4
Prompt formula or actions for automatic conversion to
column1 | column2
number1 | text1
number2 | text2
number3 | text3
number4 | text4

Answer 1

https://support.google.com/docs/answer/3094262?hl=en

Answer 2

If religious considerations allow you to have another column in the second table, then you can do the following. Let's organize a new table with three columns: row number|column1 | column2.
The first column is just pre-made numbering (in the example it starts in cells B19), in "column 1" we write the formula:
=INDEX($B$4:$E$7;ROUNDUP(B19/2);IF(ISEVEN(B19);3; 1))
and drag down
to "column2" write the formula:
=INDEX($B$4:$E$7;ROUNDUP(B19/2);IF(ISEVEN(B19);4;2))
and drag it down.
For real work, you need to replace my "$B$4:$E$7" with the range that your first plate occupies. It, of course, can be on a different sheet and even in a different Google spreadsheet. And "B19" must be replaced by the cell number from which you start numbering the rows of the second table.