Advanced Excel help

Discussion in 'Mac Apps and Mac App Store' started by chispa, Nov 30, 2009.

  1. chispa macrumors newbie

    Nov 30, 2009
    I have data in a column that I want to consolidate. To get an Idea of what I'm talking about, it's exactly the scenario at this help page:

    I want to take the data (in my case, names) that appear in both columns and compile them so they don't have blank cells between them. If you take a look at that page, there are blank cells between data points.

    The solution I have come up with is to copy that data to a separate column as values only and then Sort A-Z to cut out the blanks. Does anyone know of a more automated way to do this - perhaps one that wouldn't require a good amount of experience with Excel to operate?
  2. swiftaw macrumors 603


    Jan 31, 2005
    Omaha, NE, USA
    First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
    Now, select the cells in one column from the top of your list to the bottom.
    Make sure that all the blank cells in this selected range are the rows you want to delete.
    Press the F5 key on your keyboard (or select Edit, Goto).
    Click the Special button.
    Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
    Now choose Edit, Delete, select the Entire Row option and click OK.

Share This Page