add column
1 Topic
Changing row values based on another coumn value
Hello, I have the following table and I need to know how i can add new column (Type2) based on the following: if one of the Type column values for the same BithdayID is Creative then all values in Type2 column for the same BirthdayID should be Creative otherwise Type2 should be Basic. The following table illustrates the disiered results in Type2 column. Thank you 🙂 BirthdayID Type Type2 (New Column) Birth-1 Basic Basic Birth-1 Basic Basic Birth-4 Creative Creative Birth-4 Basic Creative Birth-4 Basic Creative Birth-7 Basic Creative Birth-7 Creative Creative Birth-7 Basic CreativeSolved2.7KViews0likes4Comments