How can I make the selected area fit cells from two other areas?

Question

excel

Please tell me how to make the column "General List" fit lines from the columns "List A" and "List B", while first the lines from List A, then from List B. The
problem of automating the combination of data from cells . You cannot manually enter anything in the "General List".

Answer 1

formulas can be done like this:
If you stretch it "with a margin", then when the source lists are replenished, the aggregate list will also be replenished.
Example:
List 1 in column A
List 2 in column B
Combined list in column F
Result: