How to group the data

[chipmunkG]

Kindy help me how to group some data became to one in one column. example 

field 1 have same data and field 2 have different and wanna group field 1 for represent field 2

state[field 1]	ptt [field 2]
JOHOR	SEGAMAT
JOHOR	MUAR
JOHOR	TANGKAK
JOHOR	JOHOR BAHRU
JOHOR	RENGET
KEDAH	KUALA MUDA
KEDAH	TANJUNG DAWAI
KEDAH	SUNGAI PETANI
SELANGOR	SHAH ALAM
SELANGOR	AMPANG
SELANGOR	SELANGOR BARAT

[fallenangel6]

please show the desired output.

[sonkumamon]

Try converting into a Pivot table.