On Mon, Oct 3, 2011 at 19:43, <openoffice.mbou...@spamgourmet.com> wrote: > How was this done in Excel? I tried creating a similar sheet in Excel 2003 > (at work) and that wouldn't sort with the merged cells either. >
I'll be honest, I don't know. I myself wonder if it is even done at all, or if this is a wish that the owner has yet to fulfill. > I think the easiest solution would be move the data from the second line of > each record into extra columns on the first line, so each record is only a > single line of the table. Then you'd be able to sort or filter on any other > column (e.g. age or position) if needed. That would be too easy! The problem is then that not all the data can be seen on the screen. He needs (this is legitimate) that all the data be seen. It is a jewelry store, there is quite a bit of data in each record. Like I said, this really should be in a database. > Depending on the number of records, > it may be easy enough to do manually, or you prefer to write a macro, or > export to CSV and process through some other software. > I think there are a few hundreds of them, actually. Like I said, this really should be in a database! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com -- ----------------------------------------------------------------- To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
