Dynamic select columns to fill "up/down"

Table 1 has column of data (4 rows) and I tranpose this data into a sigle row.

I append this query to another table and then want to fill "up or down" this appended data.

The formula looks like this:

= Table.FillUp(#"Appended Query",{"Column1", "Column2", "Column3", "Column4"})

If I add more rows to Table 1 (go from 4 rows to "N" number of rows), how do I get the Fill command to dynamically select the updated number of colmuns?

Is there a way to select the range of colums like the following:

= Table.FillUp(#"Appended Query",{"Column1" : "ColumnN"})

Thanks for the help in advance I really appreciate it!