Transpose in script

[gnmq]

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!

[Frank_Hartmann · Accepted solution]

GENERIC
load* inline [
id, date, servprovider_name, kpi, rating
1, 2019-01-01, NameA, Responsiveness, 4
1, 2019-01-01, NameA, Proactiveness, 5
];

[gnmq]

Thanks, Frank! This solution works for me.