+ Reply to Thread
Results 1 to 11 of 11

Convert 1 List into 5 and Convert 5 lists into 1

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Convert 1 List into 5 and Convert 5 lists into 1

    Hello all, i have 2 situations.

    I need to Convert 5 lists with named ranges into 1
    List1 = A2:A50
    List2 = B2:B50
    ...
    ...
    List5 = E2:E50

    Get totalList in L Column
    What's the formule i put in F columns
    I have this for 2 lists:
    Please Login or Register  to view this content.

    And other issue is to convert 1 ListTotal Into 5
    ListTotal = F2;F200

    Separated for types.
    A 1
    A 2
    A 3
    B 1
    B 5
    B 10
    C 51
    C 12412
    D 1424
    E 141
    E 12

    I need to split this to several columns, 1 for type A , 1 for type B, etc etc

    Hope you can understand.

    Thanks for your help in advance
    Attached Files Attached Files
    Last edited by brainzlp; 10-24-2015 at 04:36 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    Quote Originally Posted by oeldere View Post
    You get better help on your question if you add a small excel file, without confidential information.

    Please also add manualy the expected result in your file.
    See workbook attached, i need to know how to convert 2 things:

    Problem 1:
    columns A:C into 5 different, according to Names:
    Pet transparent
    Pet metalizado
    Pet translucido
    Embossed Transparent
    Embossed Cores

    Problem2:
    With all columns divided i need to gather in 1 pack of columns, like shown in A:C

    Hope someone can help me out, no matter if you help in just 1 problem, it's better than none.

    Thanks all in advance
    Attached Files Attached Files

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    I didn't download your file.

    I posted a reply at your other thread:

    http://www.excelforum.com/excel-form...-into-1-a.html

    However, at the time of this posting the site seems to be having trouble and I can't see my post!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516
    Quote Originally Posted by Tony Valko View Post
    I didn't download your file.

    I posted a reply at your other thread:

    http://www.excelforum.com/excel-form...-into-1-a.html

    However, at the time of this posting the site seems to be having trouble and I can't see my post!
    Thanks for your response. This is not exactly the same case as other thread. This one i need 2 things and with several columns probably i need to use other things..
    But to solve the 5 into 1 i think i just need to create more dynamic ranges for colors and codes right?

    But is there a way to convert 1 pack pf columns into 5? I mean... Doing the inverse?

    Would be great if you help me out on how to convert 3 columns shown in example. If you need more information let me know
    Last edited by brainzlp; 10-24-2015 at 07:04 PM.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    with a helpcolumn in A (see the yellow cells).

    After that I added the blue cells (H2 and L2).

    After that a VLookup (see the green cells).

    See the attached file.

  7. #7
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,256

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    or use a pivot table
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  8. #8
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    Quote Originally Posted by popipipo View Post
    or use a pivot table
    Your solution doesn't work for what i need. I will have to introduce several news rows and it needs to be automatic.

    Thanks for your help, oeldere has a good solution i will try figured his work

  9. #9
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    Quote Originally Posted by oeldere View Post
    with a helpcolumn in A (see the yellow cells).

    After that I added the blue cells (H2 and L2).

    After that a VLookup (see the green cells).

    See the attached file.
    I've seen what you created and worked properly. I will work this around and see if it can be done like that.

    Thanks for your help

  10. #10
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    I've already tested and works great, just need to adjust to my file.

    Thanks for all your help and time invested

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Convert 1 List into 5 and Convert 5 lists into 1

    You're welcome. We appreciate the feedback!

+ 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] Convert 2 lists into 1
    By brainzlp in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 10-26-2015, 07:49 PM
  2. Replies: 1
    Last Post: 12-15-2014, 08:46 PM
  3. Convert Cell Formula to Convert Text to VBA Code
    By PY_ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2014, 05:51 PM
  4. [SOLVED] convert decimal number to time : convert 1,59 (minutes, dec) to m
    By agenda9533 in forum Excel General
    Replies: 22
    Last Post: 09-15-2013, 10:43 AM
  5. what function to convert convert 34234 to 99999
    By archiles in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2008, 11:26 PM
  6. [SOLVED] How do you convert embedded drop-down lists in Excel '97?
    By RavensChild in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2005, 06:05 PM
  7. Replies: 2
    Last Post: 08-10-2005, 07:05 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