try the Case statement...something like this

select ID,
min(case type='A' then 'A' else null) type_A
min(case type='B' then 'B' else null) type_B
group by ID

Tuong Do wrote:
> Hi
>
> I have a table with data like this
>
> ID Type
> 1 A
> 1 B
> 1 C
> 2 A
> 2 C
>
>
> How can I tranfer it to this format
> ID Type1 Type2 Type3
> 1 A B C
> 2 A Null C