Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 li...
Need Help
  • AnkitBI's avatar
    AnkitBI
    7 years ago

    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.

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
7 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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.