2 Replies Latest reply on Apr 23, 2018 11:31 AM by Chandrika Pai

    combining 2 same columns obtained from 2 different data source

    Chandrika Pai

      Hi All,

       

      I have a two same columns from two different data source and I want to combine them into single column.

        

      Cod1code Name
      111Fanta
      222Mirinda
      555COKE
      444NULL
      666PEPSI
      777PEPPER
      888Lemonade
      999Diet Coke
      999Diet Coke

       

      I have attached the worksheet showing how my sample data looks after combining. Any help will be really appreciated. Thank you.