Forum Discussion

abelrmg's avatar
abelrmg
Helper II
9 years ago
Solved

Merge rows

Hi,   I have this data   How can i merge de rows and obtain one row with this structure: idticket fecharegistro1 fecharegistro2 fecharegistro5 fecharegistro7 1219 26/11/2015 30...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    abelrmg

     

    You just need to create a custom column to append "Date" with estatus, then directly pivot on that column. See my sample below:

     

     

    Regards,

abelrmg's avatar
abelrmg
Helper II
9 years ago

Hi Anonymous, i want to do this because i will calculate time between dates.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Still easy to do in the current format.  Create some sort of index marker and do your calculations.