4 Replies Latest reply: Dec 4, 2017 11:21 AM by Sunny Talwar RSS

    Merge 2 Fields from one table

    Markus Mainiero

      Hi,

       

      I would like to merge some phone numers from three fields into one.

       

      What I have:

       

      Data:

      Customer

      Private_phone

      Work_phone

      other_phone

      change_date

      Orders

       

      What I want:

      Customer

      phone_numers

      change_date

      orders

       

      The above fields with all phone numbers should lead to a row for each number.

       

      Thanx