Generate additional columns in a table based on a number

The original table has minimum no. of columns (1). there is a cell to input a number, say X.

If X=3 then, I need two additional columns to be generated next to the original column. Also, formulae that were there in the original column should be copied to the new columns.

I was looking into SEQUENCE, Power Query etc. but couldn't find a solution. can't use Macros.

the images clarify the requirement

1 - https://i.imgur.com/rUy7f3S.png

2 - https://i.imgur.com/jxw0N0k.png