Results 1 to 4 of 4

Copy Multiple Skip Blanks

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2009
    Location
    manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    83

    Copy Multiple Skip Blanks

    Hi, I need help in my attached file. i have in the file criteria named a to e. then there would be question answerable by 1-5. now i want to arrange the data in which all answers that were separated by column be in one column and that is the highlighted cells. i can do this using skip blanks but when i try it for multiple sets i am not sure it gives the right position. Thinking of this that i have 1000 sets to combine the answers in one column. Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 06-17-2014, 09:19 AM
  2. Sort multiple columns to one column, skip blanks
    By AlexCoyne in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-20-2013, 03:13 PM
  3. Skip blanks and copy data from other worksheets
    By legendkiller420 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2010, 12:53 PM
  4. Skip Blanks
    By Streng in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2009, 04:12 PM
  5. [SOLVED] Skip Over Blanks
    By Kenny in forum Excel General
    Replies: 0
    Last Post: 08-03-2005, 07:05 PM
  6. Replies: 0
    Last Post: 02-22-2005, 12:06 AM
  7. Skip multiple blanks
    By Pat in forum Excel General
    Replies: 1
    Last Post: 02-05-2005, 05:06 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