Forum Discussion

mitchell_ian's avatar
mitchell_ian
New Member
4 years ago
Solved

Edit cell in duplicated row

Hi,   I'm trying to create a table that duplicates certain rows and then clears the contents of a cell in the original row (In this case B2).   I have managed to duplicate the rows using the List...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I would just make a duplicate of your original non repeating table, filter the duplicate table to just be the rows that you want repeated, whatever criteria that might be. Once filtered, remove the duplicate column, and add a custom column from the GUI named "duplicate", and make the formula just:

     

    = null

     

    Now, you can use the Append Query button, which is Table.Combine({Table1, Table2}).

     

    Then just sort by Product, then by duplicate-descending.

     

    That's it!

     

    --Nate

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I would just make a duplicate of your original non repeating table, filter the duplicate table to just be the rows that you want repeated, whatever criteria that might be. Once filtered, remove the duplicate column, and add a custom column from the GUI named "duplicate", and make the formula just:

 

= null

 

Now, you can use the Append Query button, which is Table.Combine({Table1, Table2}).

 

Then just sort by Product, then by duplicate-descending.

 

That's it!

 

--Nate

  • mitchell_ian's avatar
    mitchell_ian
    New Member
    4 years ago

    thanks Anonymous that's worked a treat