+ Reply to Thread
Results 1 to 4 of 4

How To Skip Blank Rows and List Unique Names Into One Column

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2007
    Posts
    53

    How To Skip Blank Rows and List Unique Names Into One Column

    Hello Forum,

    I would like to think there is a way to do this (non-VBA) but I do not know how and am hoping that someone can help.

    Worksheet1 is a collection of rows from another source. I need to consolidate the rows into another spreadsheet without the blank rows from Worksheet1. A mocked up example using some rows is shown in Worksheet2. I need to copy over all the rows from Worksheet1 into Worksheet2, if, Worksheet1 has a name in column A, and, hours in any columns of G, K, O.

    Then in Worksheet2, I need to SUM all the planned hours, by column (I, M, Q), by resource. I provided an example of what this would look like at bottom of Worksheet2. I do not know how to get all of the resources at the top of Worksheet2 listed into one column without duplicating any of the resources.

    Please help if you can. Thank you very much in advance.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: How To Skip Blank Rows and List Unique Names Into One Column

    Hi -

    Pivot Table is all you need.

    event

  3. #3
    Registered User
    Join Date
    07-26-2011
    Location
    phoenix, arizona
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: How To Skip Blank Rows and List Unique Names Into One Column

    That worked, thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: How To Skip Blank Rows and List Unique Names Into One Column

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Unique names list from data validation column
    By L plates in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2017, 07:08 PM
  2. Skip Blank ROW and Unique Name
    By sanju2323 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-08-2015, 11:48 PM
  3. Replies: 6
    Last Post: 05-07-2014, 12:13 AM
  4. [SOLVED] How to insert a blank row between two rows of list names in data validation
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 10:52 PM
  5. Replies: 6
    Last Post: 07-08-2012, 03:54 PM
  6. Replies: 8
    Last Post: 03-12-2012, 05:33 PM
  7. Skip Blank rows
    By Bmxerdude2087 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2012, 11:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1