for each InstanceID transpose the column values in KPI field into separate columns...

[Raj_007]

Hi All,

 I have this dataset where i have duplicates in my instanceID because it can have multiple KPI's  - i tried to get the values in the field KPI into separate columns using the crosstab but i still have duplicates   - any help - i think i might need to use transpose and crosstab combination may be..

i have attached some sample test data - any help - thanks a lot

looking for something like

[Luke_C · Accepted solution]

Hi @Raj_007 

How's this? You're on the right track with the cross tab. I had to make a new field to repeat the KPI name in order to facilitate it being both the header and the value in the column.

[Raj_007]

Luke, That was so fast! really appreciate your help. I was very close :)

[Luke_C]

Glad you're all set!