+ Reply to Thread
Results 1 to 3 of 3

Converting data in a table into a list

  1. #1
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Converting data in a table into a list

    Hello again excelforum! I have series of large tables that needs to be converted into a list. The tables are for the user, a useable readable interface, the list is for excel to be able to more easily digest, because lists that just go down forever are easily to manipulate....but I'm stuck. I can't get it to copy over the way I need it to.

    I've tried several combinations of 'for...next' loops but can't seem to get it to do what I need....I think I'm on the right track with my choice in function... I just don't see the solution..
    I've attached a sample sheet, with a table and an example of what I would like the list to end up being. (Deleting 0's and blank values is a must! you'll see when you open it)


    listsample.xlsx

    Thanks!
    Last edited by Speshul; 04-25-2012 at 03:13 PM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,051

    Re: Converting data in a table into a list

    Try

    Change "p3" to wherever you want
    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Converting data in a table into a list

    Perfect, and easily adapted to work in my sheet This is MUCH faster than the results I was getting the other way...referencing each cell in real time instead of creating a whole table in a buffer and just plopping it in one move (i'm assuming that is whats going on here, i still have to dissect that code and figure it out :D)
    Excellent.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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