Forum Discussion

BatTodor's avatar
BatTodor
Frequent Visitor
8 years ago

Replace values to null

Hi, I want to replace all values in all selected columns to null. In general, main aim is to Fill down all cells with value, but at first need to clear all previous information. Is it possible? Best ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi BatTodor,

 

 

If you want to replace all values as null, it is maybe easier to add a new colum with all null values, delete the old column and rename the null column with the same name as the old one.

 

Br,

T

 

  • BatTodor's avatar
    BatTodor
    Frequent Visitor
    8 years ago

    Hi t_R,

    It's OK to do that if there is just one column. But if there are lots of columns - 50, 100, 1000 need to find different approach.

     

    I'm trying to find solution for lots of columns.

     

    Best regards

    Todor

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi BatTodor,

       

      Can you show some dummy data on what you're trying to do?

       

      Br, 

      T