unpivot multiple columns without duplicate other

[Anonymous]

i need to upivot the date 

[v-yalanwu-msft]

Hi, @Anonymous ;

If unpivot columns will have duplicate values, but if you want to deduplicate, you can also delete and leave only one, but for example, A is on 4-22 and 4-29, sell is 93, if unpivot, how to tell which day 93 is?
So you can give an example and show the results you want to output.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.