Sean (et al)...

The conversion didn't work exactly as noted, but by going a little deeper
with the copy, it worked like a charm. For example, rather than going to B2
and saying it was equal to A9, I went to B9 and said it was equal to A9. I
did as instructed and extended the row = column concept out to column G. I
copied two sets of addresses, including the last two blank rows of each, to
the end of the data.

One other thing I learned was that there weren't 800 addresses. There are
3185 addresses, and this work-around will allow me to spend some more time
with my family this weekend. I'm very grateful for the help.

Now, I need to go into the cell that has the City, State, Zip code and break
those into separate cells.

Many thanks.
Junto

Thanks.

"Sean Timmons" wrote:

So, in, say, cell B1, type A1.

In C1, type A2.

Go out to column G

Then, go to B2, equals A9

Same for C2 To G2.

Then, copy B1 through G2 and use fill to the botttom. Excel should have the
pattern figured out.