+ Reply to Thread
Results 1 to 2 of 2

How to combine all elements in 1 Row

  1. #1
    Registered User
    Join Date
    01-20-2017
    Location
    Berlin
    MS-Off Ver
    Business
    Posts
    12

    How to combine all elements in 1 Row

    Hi guys,

    I have a problem with combining different cells from 1 row. There's no need to create ALL possible combinations per row (reversed like: keyword1a & keyword1b + keyword1b & keyword1a) --> Just 1 of the 2 combinations is enough.

    Is there a proper way to do this?

    Basically this is what I need.



    Input
    keyword 1a keyword 1b keyword 1c keyword 1d
    keyword 2a keyword 2b keyword 2c keyword 2d


    Output
    keyword 1a keyword 1b
    keyword 1a keyword 1c
    keyword 1a keyword 1d
    keyword 1b keyword 1c
    keyword 1b keyword 1d
    keyword 1c keyword 1d

    keyword 2a keyword 2b
    keyword 2a keyword 2c
    keyword 2a keyword 2d
    keyword 2b keyword 2c
    keyword 2b keyword 2d
    keyword 2c keyword 2d


    Thanks a lot!

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: How to combine all elements in 1 Row

    Cross-posted here:

    http://www.excelforum.com/showthread.php?t=1170602

+ 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. Replies: 5
    Last Post: 06-12-2015, 07:02 PM
  2. [SOLVED] Removing specific elements from an Array based on matching elements in a different Array
    By jamesdeuce in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2014, 10:35 PM
  3. [SOLVED] Looping to combine rows based on two elements
    By thesteve in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 02:04 PM
  4. [SOLVED] combine multi workbooks into one master workbook but I want to combine only sheet 3
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-31-2013, 12:22 AM
  5. Resources for Using VBA to Manipulate Silverlight Elements like HTML Elements
    By linear_db in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-16-2013, 04:43 PM
  6. [SOLVED] Using Combine macro to combine multiple worksheets - need to modify to paste formulas
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2012, 09:07 AM
  7. can't combine VBA elements
    By cdn.mark in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2011, 04:16 AM

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