Tricky table view

[Anonymous]

Hi!

I have three columns, ID,analysis and results:

ID, Analysis, results: 

A, x, 1

B, y, 2

C, z, 1 

D, x, 3

E, z, 2

F, y, 3

Customer wishes to show these values as:

         X                         Y                           Z

A                          1                           -                           -

B                          -                           2                           -

C                          -                           -                           1

D                          3                           -                           -

E                           -                           -                           2

F                           -                           3                           -

Is this possible to do in an easy way? I have several millions of IDs and hundreds of different analyses.

Many thanks! 

[Anonymous]

Thank you for all your help!