Organizing data

S

samsg

Thanks Dave, however i don't know if what you told me could work, i
going to try to be more specific about mi problem, i used number
earlier to make it simple but my worksheet looks more like this:

----A--------------B------------------C-----
17/02/03----------------------------------
-------------Concept A---------- $1,536-
-------------Concept B---------- $537---

20/03/02----------------------------------
-------------Concept A---------- $1,987-
-------------Concept B---------- $2,372-

15/07/04----------------------------------
-------------Concept A---------- $456-
-------------Concept B---------- $987---

You can also find repeated dates(Like two or more 17/02/03), and
can't change the order of concept A and B. Any help would be reall
apreciated. Thk
 
D

Dave Peterson

You want to sort by date, right?

You could include a helper column that has the date on each row (for each
group).

Then another column that indicates what group you're on and finally one that
indicates what record you're on in that group.

----A--------------B------------------C-----
17/02/03 A 1 17/02/03----------------------------------
17/02/03 A 2 -------------Concept A---------- $1,536-
17/02/03 A 3 -------------Concept B---------- $537---

But the question still remains--how many lines per group and how are they
separated from each other (blank line, exactly 3 lines per group, only column A
has data?????)

Another alternative that I'd consider is rearranging the data, if you have 256
total fields or less.

Put everything on one row. Do your sorts by any field you want and then if you
really need to, make multiple rows for nice viewing. (I'd do all the updates in
the wide version. With Data|Filter|autofilter, it could make editing much
simpler.)
 
Top