Forum Discussion
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...
You just need to create a custom column to append "Date" with estatus, then directly pivot on that column. See my sample below:
Regards,
I would first consider why you want to do this. You can get to that format with your Power BI visuals, but leaving the data unpivoted gives you the greatest flexibility.
Hi Anonymous, i want to do this because i will calculate time between dates.
Still easy to do in the current format. Create some sort of index marker and do your calculations.