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 PatronThanks Link
So, only the blanks in position group should be replaced with that employees value in role level. If position group already as a value then ignore.
amitchandak
Super User
Super Userrosscortb , You can have a new column like
Column = COALESCE([Position Group],[Role Level])- rosscortb
amitchandak That seemed to work for my demo i sent but not my live?
- rosscortb
got 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