Merge result set based on Ticket Number

Hi

I have a result set as below.

Ticket No Customer Contact Person Reporter

100 1000001 # #

100 # 1000002 #

100 # # 1000003

The ticket number is the same. What abap statement do i use to merge the result into a single line. The result should show as

Ticket No Customer Contact Person Reporter

100 1000001 1000002 1000003

Please can someone let me know.

Thanks