Forum Discussion

LaurentZ's avatar
LaurentZ
Helper I
6 years ago
Solved

AutoFill from the Left

Dear All, Thank you for taking the time to read this.   In my Query I've this kind of Data Type1   Type2   Type3     NEW COL AA         BB                         BB CC         DD         EE   ...
Tips and Tricks
  • VasTg's avatar
    VasTg
    6 years ago

    LaurentZ 

     

    Create a custom column in Edit queries as below

     

    = if [Type3] = "" and [Type2] = ""  then [Type1] else if [Type3] = "" then [Type2] else [Type3]

     

     

     

    If it helps, mark it as a solution

    Kudos are nice too

VasTg's avatar
VasTg
Memorable Member
6 years ago

LaurentZ 

 

Create a custom column in Edit queries as below

 

= if [Type3] = "" and [Type2] = ""  then [Type1] else if [Type3] = "" then [Type2] else [Type3]

 

 

 

If it helps, mark it as a solution

Kudos are nice too

LaurentZ's avatar
LaurentZ
Helper I
6 years ago

Thank you VasTg . It works like a charm !