2 Replies Latest reply: Nov 6, 2014 6:05 PM by morua amaya jorge alberto RSS

    concatenate multiple rows into one

    morua amaya jorge alberto


      My problem is that I need to concatenate multiple rows into one row

      This is my original table


      Job Name resource name% Complete Duration
      Levantamiento de informacionAngelica Leon100%24 horas
      Levantamiento de informacionJorge Morua100%24 horas
      Entrega de InformacionAngelica Leon75%120 horas
      Diseño FuncionalAngelica Leon100%48 horas
      Diseño TecnicoJorge Morua100%4 horas
      Desarrollo/ProgramacionJorge Morua95%32 horas
      ConfiguracionesJorge Morua80%56 horas
      Pruebas UnitariasJorge Morua0%8 horas
      AjustesJorge Morua0%8 horas
      Pruebas IntegralesAngelica Leon0%3 horas
      Pruebas IntegralesJorge Morua0%3 horas
      Pruebas IntegralesAide pineda100%4 horas
      Pruebas de UsuarioAide pineda0%8 horas
      Ajustes PruebasJorge Morua0%8 horas
      DocumentacionJorge Morua0%8 horas
      FormacionJorge Morua0%2 horas
      Salida a ProduccionJorge Morua0%1 hora
      Soporte de GarantiaJorge Morua45%40 horas
      LiberacionJorge Morua0%1 hora
      LiberacionAngelica Leon100%2 hora


      I have to show the values of the "Resource Name" column in a single row in a pivot table, for this,  is required that the value of the "Resource Name" column must concatenate each value to be repeated in the column "task Name ", for example:


      Job Name resource name
      Levantamiento de informacionAngelica Leon,Jorge Morua
      Pruebas IntegralesAngelica Leon,Jorge Morua,Aide pineda
      Levantamiento de informacionAngelica Leon
      Diseño TecnicoJorge Morua


      could you tell me if there is any function to do this or how I could fix it?, thanks in advance!!!