+ Reply to Thread
Results 1 to 3 of 3

I need to take one column as Key and other as values, and get resulting sheet with one ke

  1. #1
    Registered User
    Join Date
    11-12-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Exclamation I need to take one column as Key and other as values, and get resulting sheet with one ke

    Question,
    Column A has key values. IncolumnB, few rows just have one values and few have multiple values. I.e.
    A B
    1 x
    2 x,y,z
    3 y,z,e
    4 n,m
    I need the resulting sheet as follows,
    A B
    1 x
    2 x
    2 y
    2 z
    3 y
    3 z
    3 e
    4 n
    4 m


    I have a huge list for this,
    If anyone can help.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: I need to take one column as Key and other as values, and get resulting sheet with one

    Hi, welcome to this forum,
    here is a macro you could try:
    Please Login or Register  to view this content.
    It creates a new sheet every time it is run. Attached is a workring workbook if you need it.
    Attached Files Attached Files
    Last edited by p24leclerc; 11-12-2014 at 05:14 PM.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    11-12-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Re: I need to take one column as Key and other as values, and get resulting sheet with one

    THanks, I have figured the issue.
    But thank you very much for the time.
    cheers!

+ 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] Sheet 1 button click resulting in random sheet 2 selection
    By Summers1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 05:31 AM
  2. [SOLVED] VLookup for alphanumeric values resulting in error
    By excelMTL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-21-2012, 03:10 PM
  3. [SOLVED] Positioning Numeric Values Resulting from 6 Column Array Formula
    By Sam via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2006, 12:25 PM
  4. [SOLVED] Positioning Numeric Values Resulting from 6 Column Array Formula
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2006, 10:10 PM

Tags for this Thread

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