Transposing Rows to Columns

Database
Visitor

Transposing Rows to Columns

Hello,

I have the below data in a table

1 10 A

1 20 B

1 30 C

2 10 D

2 20 E

2 30 F

 

I want to see the data in the below format:

    10   20   30 

1  A     B    C

2  D     E    F 

Can you please help me with the Query??