+ Reply to Thread
Results 1 to 4 of 4

how to convert single line data format to multiple line data format

  1. #1
    Registered User
    Join Date
    01-05-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    19

    how to convert single line data format to multiple line data format

    I am a Mtech student in Traffic and Transportation.My data base for project consist of huge amount of data (more than 10000).My topic is mode choice. There are five alternatives in the choice set for each individual.The coding for each alternatives are as follows.
    Bus-1
    Two wheeler-2
    Car-3
    Autorikshaw-4
    Format of my sample data is shown in table 1 (excel sheet attached).The required format is shown in table 2.

    Brief description
    If a person is choosing autorikshaw(ID 4) for his travel and his person id is 1001,it should appear in the required format as 4 rows with person id 1001 and the corresponding choice should be enterd in the column as person id Choice
    1001 0
    1001 0
    1001 0
    1001 1
    IN THE CHOICE COLUMN "1" SHOULD APPEAR AGAINST THE FOURTH ROW OF THE PERSON ID AS THE CODING FOR AUTO RIKSHAW IS 4

    I hope you can help me in this matter.

    Thanking you
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: how to convert single line data format to multiple line data format

    Hi pksreela,

    Refer the attached file for solution.
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    10-16-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: how to convert single line data format to multiple line data format

    See attched.

    Cheers
    BI.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-05-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: how to convert single line data format to multiple line data format

    Thank you very much Sir...............I found it very helpful..........
    Thanking you
    Sreela

+ Reply to Thread

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