Results 1 to 19 of 19

rowss data into a cell as comma delimited

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    26

    rowss data into a cell as comma delimited

    Hi all,

    My first question in this forum. Wish for a great response.

    I have a table of data. say like

    A B C D E F G H I J

    1 2 1 4 5 1 2
    1 2 3 4 4 3 3
    2 1 3 5 7 4 5
    4 5 7 8 9 6 2

    I want each row to be converted into a comma delimited cell value. For eg. it should turn the first row as 1,2,1,4,5,1,2 AND PUT THIS VALUE in the I column ( leaving out the K column or any cell that i want to ).

    so the next row should be converted to 1,2,3,4,4,3,3 and placed next to the cell where the previous row data was placed.

    so after the operation the table should be like this

    A B C D E F G H ===== I =============J

    1 2 1 4 5 1 2 ======= 1,2,1,4,5,1,2 ====1,2,3,4,4,3,3
    1 2 3 4 4 3 3
    2 1 3 5 7 4 5
    4 5 7 8 9 6 2

    and so on for all 5 rows.

    Also is there any method by which i can just convert the table into a single value moving from row to column and comma delimited. i.e. 1,2,1,4,5,1,21,2,3,4,4,3,3, and so on.

    Thanks all for any help on this !
    Last edited by Ajoo; 09-04-2013 at 11:07 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Data in Column A to Comma Delimited List
    By webdivx in forum Excel General
    Replies: 5
    Last Post: 07-11-2013, 02:16 PM
  2. [SOLVED] comma and dash delimited data to rows
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2013, 11:01 AM
  3. SUM of values in a comma delimited cell
    By Danexcel in forum Excel General
    Replies: 18
    Last Post: 01-15-2010, 10:59 AM
  4. Splitting Comma Delimited Data
    By yawnzzzz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2008, 01:11 PM
  5. Replies: 1
    Last Post: 01-15-2006, 08:30 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