Skip navigation

How to merge two nearly identical rows without duplicating?

201 Views 2 Replies Latest reply: May 13, 2012 6:52 AM by Wayne Contello RSS
sborzy Calculating status...
Currently Being Moderated
May 12, 2012 10:12 PM

In numbers, how would I merge the two rows below into one row without having duplicate data.  I just want one row with three columns that reads:

 

Steve | 12345 | open

 

 

NameID #
Status
Steve12345
Steve12345open

 

I'm very new to Numbers and spreadsheet software in general. 

 

Thanks!

 

Steve

  • Barry Level 7 Level 7 (29,095 points)

    Hi s,

     

    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?

     

    Regards,

    Barry

  • Wayne Contello Level 6 Level 6 (12,625 points)

    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:"

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.