Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a dataset:
id, date, servprovider_name, kpi, rating
1, 2019-01-01, NameA, Responsiveness, 4
1, 2019-01-01, NameA, Proactiveness, 5
I would like to transpose the data into the following:
servprovider_name, Responsiveness, Proactiveness
NameA, 4, 5
Able to advise how this can be achieved? Thanks in advance!
GENERIC
load* inline [
id, date, servprovider_name, kpi, rating
1, 2019-01-01, NameA, Responsiveness, 4
1, 2019-01-01, NameA, Proactiveness, 5
];
GENERIC
load* inline [
id, date, servprovider_name, kpi, rating
1, 2019-01-01, NameA, Responsiveness, 4
1, 2019-01-01, NameA, Proactiveness, 5
];
Thanks, Frank! This solution works for me.