More questions on Unpivot

Hellos,

I was about to make a video on unpivot & of course I can't figure the damn thing out.

1. I followed the advise of doing pivot mapping first , but I keep getting duplicates inside pivot groups every time I run it, 
2. Those duplicates result in my data also getting duplicated
3. Or maybe I am still mad and not understood how unpivot works which is highly likely

 
 
 

 

Have you tried sorting the data first?

Everything is pre sorted , since it’s one reference per line . 

Good morning

I have run some tests and found a bug  .

Please install latest version, delete duplicated groups and than it should work

It worked !!!

Creating a thread for video for others to find with files