Duplicated Data after unpivoting

[Anonymous]

Hello again , this is the second time i post for same isuue but because   you maybe dont understand what i mean exactly ^^"

My problem is with unpivot columns query , so after made unpivot columns i got duplicate data for the other coloumns that is  not related to unpivoting query and this make the value not correct, please check the sample file to understand more what i mean   :  https://drive.google.com/open?id=1ZhnLossyDM4l-hGGPJWE0x-BdAp11bhm

Thanks

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

Not sure if it is your case,please check attached file.Add Agency column to X-axis.If it is not your case,please share a simplified sample data and your expected output.

How to Get Your Question Answered Quickly

Regards,