I have a table as follows:

NAME       PLANID      NOSHARES
Russell      1            50
Russell      4            45
Mark         3            50
Mark         2           100
John         3            30
Russell      1            70
Mark         1            35
Mark         2            20

What I would like produced from an SQL Statement is :

NAME     PLANID 1    PLANID 2   PLANID 3    PLANID 4
Russell     120          0         0            45
Mark         35         120       50             0
John          0          0        30             0

Is this possible? If so, How?

Thanks in advance for your help,
Russell