To copy a value from a previous column It will copy only rows with values. but will not copy blank rows. what to do because the value from another table will be deleted when due So I want that value to be copied in another column.
Could you please provide an example doc with your problem, or give some more details? I will provide some ideas below based on the assumptions that I have made
What I would use in this example is a button to copy from one table column to another table column.
Create a column with a button:
Then copy the column(s) needed like below:
With a little bit more effort, you could put the button on the canvas, and then automate the pushing of the button. But then you need a trigger/ filter for which rows to copy.