Transposing data from row to column.(Solved)

Hi All,

I am new to the forum and I had tried to find out the resolution but was not successful.
This related to excel I have two columns assuming Col A and Colb mentioned below.I want col b data to be in horizontal against the col A and Col A should be unique.
Col A Col B
A 1
A 2
A 3
B 2
B 1
B 4
C 1
C 4
C 4
D 6
E 5
E 1
E 5

Thanks
Jags