Currently Being ModeratedMay 12, 2012 11:12 PM (in response to sborzy)
What data would be in the third column of the 'merged' row? How will Numbers know which to choose? Assuming that you've presented a simplified example of what the actual data will look like, what other possibilities exist besides a row 'missing' data in one or more columns? How are these possibilities to be handled?
Rather than having us play 'dentist on a chicken farm,' it would be more productive to start with a (more complete statement of the problem. What are the details?
Currently Being ModeratedMay 13, 2012 6:52 AM (in response to sborzy)
you can filter results using the "Reorganize" panel. To open the reorganie panel you can select the table, then select the menu item "Table > Show Reorganize Panel". The use the middle section "Show rows that match the follow:"