+ Reply to Thread
Results 1 to 2 of 2

Take Column Values (Varying Size) and Transform into 1 Line: Comma AND ' Separated Values

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    Take Column Values (Varying Size) and Transform into 1 Line: Comma AND ' Separated Values

    Hi Folks,

    Wondering if someone can point me in the right direction.

    I have a column of data that I need to put into a, b, c format (which will then be put into a query).

    I would use something like the below, but the size of Column A will vary from use to use. Is there a way to create a one-size fits all function/sub to handle this?

    Please Login or Register  to view this content.
    Last edited by athyeh; 05-29-2014 at 12:03 PM.

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Take Column Values (Varying Size) and Transform into 1 Line: Comma AND ' Separated Val

    Have a look at this.
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

+ 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. Comma Separated Cell Values to Column of Unique Cell Values
    By Nuggetross in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-02-2014, 07:24 PM
  2. [SOLVED] Macro to give the count of unique values after comparing the comma separated values
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 12:41 AM
  3. Excel 2007 : One column to txt comma separated values
    By Runnit4 in forum Excel General
    Replies: 1
    Last Post: 02-15-2011, 05:44 PM
  4. Comma separated values
    By shrikantk in forum Excel General
    Replies: 3
    Last Post: 05-18-2009, 09:52 AM

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