Results 1 to 4 of 4

Changing data from one format into another

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2010
    Location
    Dayton
    MS-Off Ver
    Excel 2007
    Posts
    23

    Changing data from one format into another

    I have a data set in excel which is the following format which I would like to convert into a text file with a different format.

    The excel sheet format is as follows:

    V C 1 2 3
    1 23 0.06 0.04 0.03
    1 12 0.09 0.06 0.03
    2 5 0.11 0.07 0.05
    2 11 0.12 0.08 0.04

    The text file should have the above data in the following format with brackets and comma:
    (V,C,1)[value]

    For example:
    (1,23,1)[0.06]
    (1,23,2)[0.04]
    (1,23,3)[0.03]
    (1,12,1)[0.09]
    (1,12,2)[0.06]
    (1,12,3)[0.03]
    (2,5,1)[0.11]
    .
    .
    .
    .
    .and so on.
    I have attached the sample sheets. Kindly help me out with this data transformation.

    Thanking you,
    Ramanan
    Attached Files Attached Files
    Last edited by ramanan256; 02-11-2010 at 08:17 PM.

Thread Information

Users Browsing this Thread

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

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