Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I need to convert row to column about this table renaming cluster that repeat
ID; DATE; TIME; CLUSTER
000200380242-0010; 11/11/2019; 07:32:31; RICE
000200380242-0010; 11/11/2019; 07:35:35; VIAG
000200380242-0010; 11/11/2019; 07:36:33; RIRI
000200380242-0010; 11/11/2019; 08:23:32; RICE
000200380242-0010; 11/11/2019; 12:08:00; VIAG
000200380242-0010; 11/11/2019; 12:08:08; POST
000200380242-0010; 11/11/2019; 12:08:14; INIZ
000200380242-0010; 11/11/2019; 15:08:33; COMP
The output would be this
ID; DATE; RICE; VIAG; RIRI; RICE 2; VIAG 2; POST; INIZ; COMP
000200380242-0010; 11/11/2019; 07:32:31; 07:35:35; 07:36:33; 08:23:32; 12:08:00; 12:08:08; 12:08:14; 15:08:33
Thank you in adavance
Take a look at this topic