Bet you don't know this answer!!

Discussion in 'BlackHat Lounge' started by Scotland, Jul 21, 2010.

  1. Jul 21, 2010
    #1
    Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Hey ppl,

    Ive got keywords entered into a spreadsheet file. There are 4 columns of keywords, the first has phrases like...how do i. The second column contains words such as lose weight, the third contains keywords like quickly and easily...

    Anyway, ive got about 50 keywords in each column, and what i would like to do is mix each and every keyword together so that i create 2 word, 3 word and 4 word phrases.

    I need to cover every combination basically and was wondering how i could a) do this and b) automate it...

    I will gladly share all the keywords to anyone who can help me out
     
  2. Jul 21, 2010
    #2
    BassTrackerBoats

    BassTrackerBoats Super Moderator Staff Member Moderator Jr. VIP

    Joined:
    Mar 10, 2010
    Messages:
    20,043
    Likes Received:
    36,941
    Occupation:
    Linkpushing, A New Era - Now Live!
    Location:
    As Close to Heaven as One Can Get!
    Home Page:
    • Thanks Thanks x 1
  3. Jul 21, 2010
    #3
    loclhero

    loclhero Supreme Member

    Joined:
    Jun 11, 2007
    Messages:
    1,455
    Likes Received:
    2,416
    Gender:
    Male
    Location:
    Copperhead Road
    Fuck...my wife just got on a plane for a biz trip. I won't hear from her until later tonight but I'll send this to her. She is the goddess queen of excel, could probably knock it out in a minute or two.
     
    • Thanks Thanks x 3
  4. Jul 21, 2010
    #4
    AtomBoy

    AtomBoy Junior Member

    Joined:
    Feb 21, 2008
    Messages:
    119
    Likes Received:
    121
    Location:
    Venice, CA
    that is an excellent question!
    you could probably do it with a macro. Maybe
    You can definitely do this in access or some other db program.
     
  5. Jul 21, 2010
    #5
    Chronos

    Chronos Junior Member

    Joined:
    May 5, 2010
    Messages:
    126
    Likes Received:
    294

    Am I nerd for thinking this would be a +1 in a girl?
     
    • Thanks Thanks x 1
  6. Jul 21, 2010
    #6
    Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Ive found a website that allows you to combine the 3 colums, you can only enter in a maximum of 12 per column, but this does exactly what i want. It looks like its a php script, id actually pay for this script cos i see good potential for it....

    Any idea how to get the php script?
     
  7. Jul 21, 2010
    #7
    AtomBoy

    AtomBoy Junior Member

    Joined:
    Feb 21, 2008
    Messages:
    119
    Likes Received:
    121
    Location:
    Venice, CA
    what's the site?
     
  8. Jul 21, 2010
    #8
    Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Sorry , im so stupid!!

    hxxp://www.searchenginepromotionhelp.com/m/keywords-combiner/word-combinations.php

    If this could be extended to more words in each colums, mixed with product keyword and buying keywords, this could be quite a good tool to source out some longtail keywords.

    Anyone else think this??
     
  9. Jul 21, 2010
    #9
    bertbaby

    bertbaby Elite Member

    Joined:
    Apr 15, 2009
    Messages:
    2,020
    Likes Received:
    1,503
    Occupation:
    Product marketing
    Location:
    USA
    Home Page:
    Use a concatenation formula in Excel in a separate column to combine labels or strings:

    [FONT=Arial,Helvetica][SIZE=-1]Step-by-Step:[/SIZE][/FONT]
    [FONT=Arial,Helvetica][SIZE=-1]Cells F129 contains Mary and G129 contains Brown[/SIZE][/FONT]
    [FONT=Arial,Helvetica][SIZE=-1]Another cell, say, F132 contains the concatenation formula: =F129&G129[/SIZE][/FONT]
    [FONT=Arial,Helvetica][SIZE=-1]F132 will display: MaryBrown[/SIZE][/FONT]
     
    • Thanks Thanks x 2
  10. Jul 21, 2010
    #10
    Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    That worked a treat too!!
     
  11. Jul 21, 2010
    #11
    essares1

    essares1 Junior Member

    Joined:
    Apr 27, 2009
    Messages:
    163
    Likes Received:
    27
    Send me the list. I will create 50x50x50x50 lines and send it to you. How I do it? I program it.
     
  12. Jul 21, 2010
    #12
    3gpstreet

    3gpstreet Newbie

    Joined:
    Nov 20, 2008
    Messages:
    15
    Likes Received:
    59
    Use black coffee and Excel formula to combine the sells and rows
     
  13. Jul 21, 2010
    #13
    AtomBoy

    AtomBoy Junior Member

    Joined:
    Feb 21, 2008
    Messages:
    119
    Likes Received:
    121
    Location:
    Venice, CA
    • Thanks Thanks x 1
  14. Jul 21, 2010
    #14
    Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    This is a smashing tool old chap.

    Much thanks n stuff given!!