Retain information in 3 rows and sort by column

Hello,
I'm trying to sort by location but retain name with two addresses in 3 separate rows.

NAME Location
Fname Lname 7
Physical Address
Mailing Address
Fname2 Lname2 5
Physical Address
Mailing Address

Name and location are both in different columns.
If anyone can please help out. Thanks.

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

If you put the location number in all 3 cells of every person, and you sort your data only on Location, all 3 lines stay together

Ok. Are you allowed to fill column G with extra data?
In G2 type =IF(F2="";G1;F2) and drag down. This fills the extra location numbers that you would need to use my previous solution.

I think to get L-Drr's formula to work you need to replace the semi-colons with commas so this
=IF(F2="";G1;F2)
should be this
=IF(F2="",G1,F2)

Cool, don't forget to give L-Drr the credit. Rep points are always welcome to forum contributors.
I think for some reason overseas versions of excel seem to use semi-colons where we typically use commas as I've seen that appear in other formulas but I know whenever I see them they won't work in whatever I'm trying to use them in.

Haha true, maybe it's time to put that in my signature