Organizing data

S

samsg

Hi, i have a list like this:

2
23
27
...

1
11
34
...
...

I need to arrenge the blocks of data in order from A to Z, so it woul
look like this

1
11
34

2
23
27

Do you know how can i do this, any help would be really apriciated
Thk
 
F

Frank Kabel

Hi
not really sure what't the logic behind this grouping. They is '34' in the
same group as '1' and '11'
 
D

Dave Peterson

I think I'd use a column of helper cells (say a new column A).

Put the first value in each group in column A of all the rows in the group.

so it would look like:

2 2
2 23
2 27
..
1 1
1 11
1 34
..

Then you could sort the complete range by column A with a secondary sort of
column B (if you needed to).

There might be some formulas you could use to populate that helper column of
cells, but you'll have to post back with more details.

Groups always come in 3. There's a gap of x rows between groups. Whatever
defines the data...
 
Top