i have situation for my report

table1

no name prize

1 A 1000

1 B 2000

1 C 3000

1 D 4000

1 E 5000

2 A 1500

2 E 5500

3 E 6000

i want my report like this

A 1000 B 2000 C3000 D 4000 E 5000

A 1500 B null C null D nulll E 5500

A null B null C null D null E 6000

can anyone help me ?