3 Replies Latest reply: Oct 20, 2015 10:20 AM by Sebastian Lettner RSS

    How can I merge data from a few columns in one column

    Виталий Чуприна

      For example I have following table:

       

      A                       B                  C

                            

      Delivery            Color            StyleDesc

      Dept                 ColorDesc    Store

      Manufacturer     Style            StoreNumber

       

      I want to merge  3 columns into one column, like this:

       

         D

       

      Delivery           

      Dept                

      Manufacturer

      Color     

      ColorDesc

      StyleDesc      

      Store

      StoreNumber

       

       

      Please advise the best way

       

      Thanks,

      Vitaliy