+ Reply to Thread
Results 1 to 10 of 10

Keywords going down but I need them to go across

  1. #1
    Registered User
    Join Date
    08-26-2019
    Location
    Chattanooga
    MS-Off Ver
    2013
    Posts
    23

    Keywords going down but I need them to go across

    If you look in column A I have a list of Keywords going down. I am trying to see if there is a way to put those keywords in a row going across like I have in row B. I have found that doing this " =A1&"," " will put a comma behind each letter.

    I am self teaching as I go along here. I thank you all for your patience!

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Keywords going down but I need them to go across

    Hi ChuckyBuck,

    It sounds like you are trying to concatenate everything in column A? How about!

    https://www.excelforum.com/tips-and-...geravatar.html
    HTH
    Regards, Jeff

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,095

    Re: Keywords going down but I need them to go across

    copy col A values, then in cell in col B click and right click, >> paste special >> values and transpose would seem like the easiest way to do this.

    given Jeff's reply maybe I'm misunderstanding the request.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,776

    Re: Keywords going down but I need them to go across

    If you look in column A I have a list of Keywords going down
    Hi
    no attachment = no column A ...
    ( see yellow banner to attach a sheet)

  5. #5
    Registered User
    Join Date
    08-26-2019
    Location
    Chattanooga
    MS-Off Ver
    2013
    Posts
    23

    Re: Keywords going down but I need them to go across

    I attached it but I don't see it either. Redoing it.
    Attached Files Attached Files

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Keywords going down but I need them to go across

    Did you look at the link I posted? It will do what you want.

  7. #7
    Registered User
    Join Date
    08-26-2019
    Location
    Chattanooga
    MS-Off Ver
    2013
    Posts
    23

    Re: Keywords going down but I need them to go across

    I looked but couldn't follow it. Went crosseyed. lol

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Keywords going down but I need them to go across

    Give this a try
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-26-2019
    Location
    Chattanooga
    MS-Off Ver
    2013
    Posts
    23

    Re: Keywords going down but I need them to go across

    Thanks You. I will pick this apart.

  10. #10
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,066

    Re: Keywords going down but I need them to go across

    You're very welcome.

+ 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. Search Keywords and Delete Every Line Except Keywords
    By area51plustax in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-16-2018, 12:30 PM
  2. Replies: 1
    Last Post: 03-23-2016, 03:28 PM
  3. [SOLVED] VBA looking for multiple keywords and return concatenated keywords, that were found
    By Kpacu007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-10-2014, 06:03 AM
  4. [SOLVED] Search for keywords and copy rows containing keywords to new sheet
    By lenorsk in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-15-2013, 06:54 AM
  5. [SOLVED] HDI - Return multiple keywords in a text column based on a set of available keywords
    By zneiley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-25-2013, 01:32 PM
  6. Help with IF and keywords
    By mgoldie1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-05-2012, 01:16 AM
  7. VBA keywords
    By loneman in forum Access Tables & Databases
    Replies: 7
    Last Post: 01-29-2011, 10:51 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