Need More Details, may be Sheet

Hardeep kanwar

"rciolkosz" wrote:

In a downloaded excel report, the County name is in cell B1 with the list of
cities in C5 through C how ever many. Then another County name appears a few
rows after that to start another batch of cities. Question is, I need the
County name to apear in the cell before the city name cell. I do not want to
cut and paste into it either. I am looking for an automated formula or
something.