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

Sample Test Data.xlsx

Luke_C

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.

New Workflow2.yxmd