PHP Code:
[PHP] 
[/PHP]Well, the Power Query pivot is the simply answer, as p45cal proposed.

The settings is used are shown in the attached picture.

Capture.jpg