finding maximum value in range containing same value

finding maximum value in range containing same value

I have data
A B
1 100
1 300
1 200
2 100
2 500
3 100
3 300
3 200
I want to select maximumof(B) for same value in column1 Output should be
A B C
1 100 300
1 300 300
1 200 300
2 100 500
2 500 500
3 100 300
3 300 300
3 200 300
How can I achieve this? I have tried
={Max(if(A:A=A1,B:B))} This gives me max value for 1 i.e. 300. How can I
copy this formula for other group of cells? It gives message You Can not
move array values.