Forum Discussion
rosscortb
Post Patron
Post PatronFill blanks in column with a value based on a condition
Hello I have a column called position group which contains some values and some blanks Also have a column called role level with some values and no blanks For only the blanks in position gro...
rosscortb , You can have a new column like
Column = COALESCE([Position Group],[Role Level])
rosscortbPost Patron
Post Patronamitchandak That seemed to work for my demo i sent but not my live?
rosscortbPost Patron
Post Patrongot it i need to go into the excel file select the blanks and delete the cell, might have been a space or something hidden in it. thanks