+ Reply to Thread
Results 1 to 10 of 10

convert master list into sub-levels format

  1. 08-08-2019, 11:47 PM #1
    gentle_20052006
    gentle_20052006 is offline
    Registered User
    Join Date
    07-31-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    convert master list into sub-levels format

    Hello,

    I have originally posted my query in the Ozgrid but waiting for results in the mean while i am posting it here for quick response


    I need some help to convert my master list into sub-level list from left-to-right. Could anyone try and solve using vba since my list is very long?

    Thanks
    Attached Files Attached Files
    Last edited by gentle_20052006; 08-09-2019 at 02:19 AM.
    Reply With QuoteRegister To Reply
  2. 08-09-2019, 12:44 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: convert master list into sub-levels format

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-09-2019, 02:24 AM #3
    gentle_20052006
    gentle_20052006 is offline
    Registered User
    Join Date
    07-31-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: convert master list into sub-levels format

    I am sorry I have done cross posting as I was not getting help from helpful and adorable volunteers in Ozgrid.com. I am sorry for cross-posting it here.
    Reply With QuoteRegister To Reply
  4. 08-09-2019, 02:26 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,780

    Re: convert master list into sub-levels format

    Thank you. Here is the link: https://www.ozgrid.com/forum/forum/h...hild-relations

    Please keep the forum rules in mind in future: there are not many, but they are important.
    Reply With QuoteRegister To Reply
  5. 08-09-2019, 12:13 PM #5
    gentle_20052006
    gentle_20052006 is offline
    Registered User
    Join Date
    07-31-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: convert master list into sub-levels format

    Someone help me
    Reply With QuoteRegister To Reply
  6. 08-09-2019, 03:00 PM #6
    jdawson
    jdawson is offline
    Registered User
    Join Date
    03-06-2006
    Location
    South Central Pennsylvania
    MS-Off Ver
    MS Office Pro Plus 2016, on Window 10
    Posts
    27

    Re: convert master list into sub-levels format

    Wow. The structure looks quite convoluted at first.

    The Item Code and Level-1 appear to be equivalent to being unique keys for a list or whatever.

    I see that for any Level-1, there can be multiple values for Level-2 and for any Level-2 there can be multiple values for Level-3. Can the same be true for Level-4 and Level-5? Also, is there a limit to the number of levels?

    This looks like it could be accomplished with some kind of recursive search and constructing a multi-dimension array or a dictionary of dictionaries.

    Regards.
    Reply With QuoteRegister To Reply
  7. 08-09-2019, 07:25 PM #7
    gentle_20052006
    gentle_20052006 is offline
    Registered User
    Join Date
    07-31-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: convert master list into sub-levels format

    Hi

    There are only 5 levels.To make the left column item we need the right column recipe and it goes up to 5 levels.

    Thanks
    Reply With QuoteRegister To Reply
  8. 08-10-2019, 02:52 AM #8
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: convert master list into sub-levels format

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  9. 08-10-2019, 03:09 AM #9
    gentle_20052006
    gentle_20052006 is offline
    Registered User
    Join Date
    07-31-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: convert master list into sub-levels format

    Thank you very much for your valuable support. I will test and come back and once again thank you for your priceless effort.
    Reply With QuoteRegister To Reply
  10. 08-15-2019, 01:31 AM #10
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: convert master list into sub-levels format

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Different lists from a available single list in desired format considering master-sheet
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 02-26-2018, 10:39 AM
  2. [SOLVED] Different lists from available single list in desired format considering master-sheet
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-26-2018, 08:14 AM
  3. Convert hierarchy list to flat table format
    By tbucki1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-14-2016, 04:19 PM
  4. Macro to convert Supplier order from Master Build List.
    By Seabast in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-30-2016, 01:03 PM
  5. Convert Pivot Table Tree to XML with 5 child levels
    By Neo444 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2013, 03:45 PM
  6. [SOLVED] Create master list from multiple sheets in the same format
    By malmandras in forum Excel General
    Replies: 1
    Last Post: 05-09-2013, 01:59 PM
  7. [SOLVED] Convert Excel 2003 to 2010 - Levels of Nesting
    By Lewej23 in forum Excel General
    Replies: 7
    Last Post: 08-09-2012, 10:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1