How to select data: Row as Column

Question

Hi all
I have data as table below:

ID       ProductID            Name
----------------------------------------------------
1           1                        AAA
2           1                        BBB
3           1                        CCC
4           2                        DDD
5           2                        EEE
6           2                        FFF
7           3                        GGG
8           3                        HHH
9           3                        III

When show on gridview I don't show this.
I want to show below:

ID      ProductID     Name1     Name2        Name3
---------------------------------------------------------------------
1            1               AAA          BBB             CCC
2            2               DDD         EEE              FFF
3            3               GGG         HHH             III

Please help me.

Thank Advance