+ Reply to Thread
Results 1 to 8 of 8

Concatenate the values in a column one by one with multiple entries in another column

  1. #1
    Registered User
    Join Date
    12-24-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    99

    Question Concatenate the values in a column one by one with multiple entries in another column

    Can anyone please help me with concatenation? I need to convert 'Original data' to 'Concatenated data'.

    Original data:

    a 1
    b 2
    c 3

    Concatenated data:

    a1
    a2
    a3
    b1
    b2
    b3
    c1
    c2
    c3

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Concatenate the values in a column one by one with multiple entries in another column

    Please attach a sample workbook with expected output for better understanding

  3. #3
    Registered User
    Join Date
    12-24-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Concatenate the values in a column one by one with multiple entries in another column

    @Sixth Sense: Hi thanks for responding, i have attached the sheet.
    Attached Files Attached Files

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Concatenate the values in a column one by one with multiple entries in another column

    Not sure which data needs to be concatenated with which one

    Please give some description about your data and the expected output for better understanding

  5. #5
    Registered User
    Join Date
    12-24-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Concatenate the values in a column one by one with multiple entries in another column

    Hi Sixth Sense,

    In the sheet provided, I need to concatenate Name with Code and retrieve the combinations for each name and code. I am illustrating the same example provided in the sheet:

    Name Code
    Johnson i01
    Smith i02
    James i03

    I need following combination for each Johnson, Smith, James in 'Name' column with each entry in 'Code' column:

    Johnsoni01
    Johnsoni02
    Johnsoni03

    Similarly i need combinations for the rest:

    Smithi01
    Smithi02
    Smithi03
    Jamesi01
    Jamesi02
    Jamesi03

    I hope this is clear. Let me know if you need further clarifications.

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Concatenate the values in a column one by one with multiple entries in another column

    Sorry I have seen some other file and requested you for a brief.

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Concatenate the values in a column one by one with multiple entries in another column

    Try this code....

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    12-24-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Concatenate the values in a column one by one with multiple entries in another column

    Thank you so much Sixth Sense! Worked like a charm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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