Macro to re-Arrange data based on 2 columns values

I need help in achieving the below scenario using Macro or any other alternative:
I have data in a sheet whose cloumn A contains teams in random order and ColumnB contains its members.
ColumnA CloumnB
team1 Monty1
team1 Javier
team2 Alex
team3 Manish
team1 Daniel
team2 Howdy
team1 Ballex
team1 hunter
team2 Banter
team2 Carter
team3 Lord
team3 Sandy
team3 Zoro

I need the data to be arranged in sheet1 in just a single column where each Team will be followed by its members just below it.
ColumnA
team1
Monty1
Javier
Daniel
Ballex
hunter
team2
Alex
Howdy
Banter
Carter
team3
Manish
Lord
Sandy
Zoro

Why not just sort by column A and then the names will be grouped by team?

Originally Posted by StephenR

Why not just sort by column A and then the names will be grouped by team?

Sorting isnt a solution here.The solution is just a part of bigger picture.So in this case its exactly how we need the data to be placed in just 1 column so that we can do other things relevant to it.

Any alternatives please?