+ Reply to Thread
Results 1 to 7 of 7

Joined Data To CSV Format (1 column)

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Joined Data To CSV Format (1 column)

    hi expert..

    could you help me & figure it out, how to joined data (from excel sheet to csv file) in one column..

    please, see my attach file..2 files (data & expected result)

    any assistance is greatly appreciated...

    john m
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Joined Data To CSV Format (1 column)

    Apologies but Im not sure what you're after as a desired result? at first it looked like you wanted to output the file to csv, not a problem but then on further investigation you appear to have a column heading in each record but then values that dont even correspond to that record in the original (or even any record).

    eg line 1 of desired result shows "FAT",26.11,1.42,0.45,

    the 26.1 seems fine thats the amount in the FAT column for that record however 1.42 and 0.45 dont appear in the original table at all?
    If someone has helped you then please add to their Reputation

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Joined Data To CSV Format (1 column)

    you are right, i' m sorry for :
    e.g
    "FAT",26.11, (should be)

  4. #4
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Joined Data To CSV Format (1 column)

    bump-bump...

  5. #5
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Joined Data To CSV Format (1 column)


    Hi,

    use Save As and choose csv file …

  6. #6
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Joined Data To CSV Format (1 column)

    the desired output though doesnt match the input

  7. #7
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Joined Data To CSV Format (1 column)

    thank guys...i think my input & desired result have match...

+ 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. Macro need Arranging column data in Quiz format using transpose and Text to Column Feature
    By successramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2014, 02:58 AM
  2. Replies: 2
    Last Post: 12-07-2013, 02:34 AM
  3. Yooooooo Data Analyst here, just joined
    By My335iTT in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-21-2013, 09:11 PM
  4. Format Column data to be Col and Row
    By techissue2008 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2008, 02:20 AM
  5. SQL query JOINED Data from which Table?
    By Abdul in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2006, 02:50 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