Assuming you have a unique list of locations starting in A12. (if you don't you can use Data|Sort and Filter|Advanced to create one).

Then in B12 apply formula:

=IFERROR(INDEX($B$3:$B$8,SMALL(IF($A$3:$A$8=$A12,ROW($A$3:$A$8)-ROW($A$3)+1),COLUMNS($A$1:A$1))),"")
confirmed with CTRL+SHIFT+ENTER not just ENTER and copy across as far as needed and down.