kb

Is your data consistent?

i.e. sets of 3 or 4 or 5? Like so....

Name
Address
City
State
Zip
Name
Address
City
State
Zip

If so, there are a couple of methods, one using formulas, the other using a
macro.

Assume your data starts in A2.

In B2 enter this formula and drag/copy across to F2 and down until you get
zeros appearing.

=OFFSET($A$1,(ROW()-1)*5+COLUMN()-1,0)

The 5 should be adjusted to whatever number constitutes a set.


Gord Dibben Excel MVP



On Wed, 2 Mar 2005 15:43:01 -0800, "kb" <kb@discussions.microsoft.com> wrote:

>I need to sort a long address list, that is listed down not accross.
>name-address-city, is that possible