If you want to replace the content of a column with a given value or with the content of another column, you can use the Fill Cells with Value function.
- Select a column in which you want to replace values.
In the Functions panel, type Fill cells with
value and click the result to open the options for the associated
- Click the Submit button to apply the function.
The content of the selected column is replaced with the data you selected.
Tip: This transformation can also be performed by using the Magic fill function.