1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Tool (or Excel function) to add 2 or more columns of keywords together?

Discussion in 'Black Hat SEO' started by muchacho, Apr 28, 2011.

  1. muchacho

    muchacho Supreme Member

    Joined:
    May 14, 2009
    Messages:
    1,293
    Likes Received:
    187
    Location:
    Lancashire, England.
    Let's say I had column 1 of:

    how to
    how do I
    I want to

    and column 2 of:
    rob a bank
    sleep with my pet horse

    and column 3 of:
    tomorrow
    whenever I want


    it'll add each column in every possible way.

    I know with Excel you can use the concatenate function, but with that it'll just join the same row together.

    What I want is to go through every possible order.

    Any ideas? I once had a free tool which did this, but I can't for the life of me remember it's name.

    Come to think of it, a spinner would probably work with just putting the keywords in {keyword|keyword2}{keyword3|keyword4} format but a tool where I just list them all in each section would be more user friendly.
     
    Last edited: Apr 28, 2011
  2. millwall

    millwall Newbie

    Joined:
    Aug 23, 2009
    Messages:
    11
    Likes Received:
    1
    Google Keyword Combiner
    Sorry - I can't post urls
     
    • Thanks Thanks x 1
  3. gorang

    gorang Elite Member

    Joined:
    Dec 6, 2008
    Messages:
    1,891
    Likes Received:
    1,650
    Occupation:
    SEO Consultant - Marketing Strategy
    Location:
    UK
    I think scrapebox can actually do this.
     
  4. muchacho

    muchacho Supreme Member

    Joined:
    May 14, 2009
    Messages:
    1,293
    Likes Received:
    187
    Location:
    Lancashire, England.
    Thanks for that bud. Very simple and works well.

    Re: Scrapebox, I own it, but not aware of it having the format I've mentioned. I think it would just take the words as individual and expand on them, not necessarily including all the possible long tail keyword phrases I'd be looking for.