Hi All,
In my data table there are variables like Current_Year_Name, Past_Year_Name,Target_Name. These columns have same values except for blanks. That is, Column 1 will have most values of column 2 and some blanks and some values which are not in Column 1.Same is the case with Column 3.I need create a column (Name) where the non blank values will be displayed.Please see the below table as an example and my question is how I can create column ‘Name’. Thanks in advance
S.No. Current_Year_Name Past_Year_Name Target_Name Name
1 John John John
2. Kevin Kevin Kevin
3. Mark Mark
4. Joseph Joseph Joseph Joseph