Results 1 to 3 of 3

Manipulate and arrange table data into summary list

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Manipulate and arrange table data into summary list

    Hi Everybody,

    I'm looking to manipulate data I have in a table and arrange it into 2 columns

    For example (I have used the number 1 as a true statement)

    Name,Job1,Job2,Job3
    P1,1,1,0
    P2,0,1,1
    P3,0,1,0

    I would like to output a list of each person with the job(s) they assigned, however each new job must be on a different line

    Name,Job
    P1,Job1
    P1,Job2
    P2,Job2
    P2,Job3
    P3,Job2


    Are they any examples somebody could point me towards, or functions I should be looking at?
    Thanks very much!
    Last edited by DavidSpackman; 07-28-2010 at 12:58 AM. Reason: Bad title

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