Want help with Numbers reorganize function

[gorgewarehouse]

I have a Numbers 2009 (I think) spreadsheet that is 15 columns wide and 1,040 columns high. I want to filter by criteria based on the content of a certain column, so I click Reorganize in the toolbar. Under "Search rows that match the following", I select the column heading and type in the criteria (for example, Contains > Movie). However, I cannot select the checkmark box next to where it says "Search rows that match the following". The checkmark box is grayed out. Why is this disabled? When I try to add more criteria, the computer just "burps" and quickly flashes the check before quickly taking it away.

I think it's fairly recent. I'm fairly certain that it worked with the first 900 rows. I couldn't find anything in the Numbers help file about it. I posted this question to answers.yahoo.com but nobody replied. Please help!

I'm running a PowerPC G5 PowerMac upgraded to 4GB RAM. I'd call myself something of a newbie.

Thanks to all posters in advance.

 

[gorgewarehouse]

Still having trouble

I still have not figured this out. I still cannot filter columns. I don't like to "bump" messages any more than anyone else likes having them bumped. I hope waiting a week is forgivable. I was just wondering if people simply don't know the answer, or if they have another reason for not replying.

i guess I'm more insecure than an idiot. However, if you solve this issue, you can call me anything you want!

Please help! Thank you.

-Kent

 

[gorgewarehouse]

I figured it out

In case any future readers see this through Google or MacRumors searches, I'm posting my solution. I merged two cells together (G999 and G1000). After I unmerged the cells, I was able to filter as I wanted to. Note to self: no more cell merging.

Anyway, I thought someone might be interested in seeing this. Have a great day!

 

[v-raptor]

thanks for following up

just a line to thank you for sharing your solution.
It was helpful and saved me from looking any further