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.

Assuming you have amounts in Col A, City Name or Number of beds in Col B, and
Number of baths in Col C, starting at Row 1

Enter
=B1 in D1
and this in D2
=IF(OR(ISNUMBER(A1),B1=""),D1,B1)
and copy down...

This will look for a number in Col A, if found just copy the City name from
previous row else pick up the next city from Col B.
This will give you the city name against each row. You can Copy and PASTE
SPECIAL-Values to get rid of formulas, Filter on Blank in Col A to get rid
of unwanted rows and you are set...


"Busanlyst" wrote:

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.