Group Rows in Sheet based on column value

I want to group the rows together based on the value in column A, just like below.
AAA120 2
AAA121 A
CCC200 1
AAA131 4
BBB120 2
AAA141 2
BBB100 2
BBB130 1
CCC300 3

so i want to place the rows having column value AAA,BBB,CCC one after the other i.e., as below
AAA120 2
AAA121 A
AAA131 4
AAA141 2
BBB100 2
BBB120 2
BBB130 1
CCC200 1
CCC300 3
how to accomplish this? whether it's possible to do with formula in sheet cells?
Advance thanks for the feed back...

Select your data and click the A-Z icon

Maybe a couple of helper columns

Say data in Col A starting in A1. Enter this formula in B1

=LEFT(A1,1)

and this in C1

=MID(A1,4,3) drag down as required

Then select Column A to C and sort on Column B then by Col C.

You can then delete the helper columns

HTH

VBA Noob