ALTER TABLE WITH VALUES FROM SELECT
@nbk had given what you want - atleast what you made us to understand.

But...

Think of re-designing your whole job. Do not go by your fluctuating number of columns. There are better ways. json is one. Transactional database is what is been used in lot of projects. Those are the right methods to store / retrieve than having variable number of columns.