9 Replies Latest reply: Sep 29, 2010 2:06 PM by Luis Laura RSS

    How Trasform Row in Column???

    federico casarotto

      Hi all!

      I have a big problem!

      I'm loading a crm table where there are different contacts (Sales Manager, Edp Manager, etc) for the each customer.

      I have to obtai a unique row for any Customer code with all contact.

      Example:

      Table A:

       

      CustomerContactTypeEmal
      abc ltdmr Coopercfocooper@abc.com
      abc ltdmr Laivesciolaives@abc.com
      gold ltdmrs Bluesedpblues@gold.com
      gold ltdmrs Greenciogreen@gold.com
      gold ltdmrs Blackcfoblack@gold.com


      New Table:

       

      CustomerContact1Type1Emal1Contact2Type2Emal2Contact3Type3Emal3
      abc ltdmr Coopercfocooper@abc.commr Laivesciolaives@abc.com
      gold ltdmrs Bluesedpblues@gold.commrs Greenciogreen@gold.commrs Blackcfoblack@gold.com


      Every suggestion will be appreciate!!!!

      Thanks!!!