I have the following workheet with a lot more cities and address information
rows and I would like to be able to filter according to City but the
worksheet is formatted as follows so I cant. The worksheet is grouped by city
but I cant filter by city.

Bel Air City
825,000 4 Beds 4 Baths
3,550,000 3 Beds 5 Baths
7,695,000 7 Beds 9 Baths

Beverly Center City
324,000 2 Beds 1 Baths
399,000 2 Beds 1 Baths
415,000 1 Beds 2 Baths
425,000 1 Beds 2 Baths
464,800 2 Beds 2 Baths
499,900 2 Beds 2 Baths
515,000 2 Beds 2 Baths

How can I apply the City "Description" to each of applicable row so that i
could filter by city, instead of manually copying each city name and pasting
it to each applicable row? So for the first group I am trying to get the
following:

Bel Air City 825,000 Los Angeles 4 Beds 4 Baths
Bel Air City 3,550,000 Los Angeles 3 Beds 5 Baths
Bel Air City 7,695,000 Los Angeles 7 Beds 9 Baths

And so on for each city.
Do I need a macro or can i use a function? Please Help. Thank you.