Forum Discussion

rpatel-cct's avatar
rpatel-cct
New Member
7 years ago
Solved

AutoFill Blank Cells

Hi All, 

 

Wondering if the following is possible:  In my data set I have 2 columns, Unit and SubUnit.  Within each Unit are multiple SubUnits (ex. Unit 2000 - 2001, 2002, 2003.. as SubUnits).  

There are instances where within a Unit there is no listed subunit. When that happens, the SubUnit cell is blank. I was wondering if there was a way to put in a formula or script that would detect the blank, and copy over the Unit value into the Subunit (ex. Unit 2300 - blank Subunit... would want to copy over 2300 into the Subunit as well)

 

Here is a sample of my data:

UnitSubUnit
20002001
20002001
20002002
20002004
2300 
22002201
22002203
2300 
2300 
20002003
2400 
22002202
22002201
2400 
22002205

 

Any help/guidance is very much appreciated!

Thanks,

RP

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Since the  blanks will be null when you import that, the easiest thing would to be create a new column with the following and then deleting the original SubUnit

    =if
    [SubUnit] = null
    then
    [Unit]
    else
    [SubUnit])