Pivot table in winform vb.net

Question

can any explain me how do i pivot table in vb.net winform or any inbuilt feature for that

 

 

mine data return by query 

1 BHK ( 636 Sq. Feet )   CA   636

1 BHK ( 658 Sq. Feet )   CA   658

2 BHK ( 962 Sq. Feet )   CA   962

2 BHK ( 970 Sq. Feet )   CA   970

2 BHK ( 1004 Sq. Feet ) CA  1004

2 BHK ( 1011 Sq. Feet ) CA  1011

3 BHK ( 2126 Sq. Feet ) CA  2126

1 BHK ( 630 Sq. Feet )  UjP    630

1 BHK ( 640 Sq. Feet )  UjP    640

2 BHK ( 1043 Sq. Feet )  UjP  1043

 

 

 

i want to display like this 

Pname	CA	CA	CA
PPname	1 BHK ( 636 Sq. Feet )	1 BHK ( 658 Sq. Feet )	2 BHK ( 962 Sq. Feet )
Area	636	658	962

 

please help me