Dynamic select columns to fill "up/down"

[Anonymous]

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!

[AnkitBI · Accepted solution]

Hi - Try Below.

Table.FillDown(#"Appended Query",Table.ColumnNames(#"Appended Query"))

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

[Anonymous]

Excellent suggestion!  Its exatcly what I needed! Thank you!

---

@AnkitBI wrote:

Hi - Try Below.

Table.FillDown(#"Appended Query",Table.ColumnNames(#"Appended Query"))

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

---