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!

If this is a one-off task a quick cheat (assuming you have a lot of data) is to use a Multi Consolidation Pivot Table to transpose the data set ... you can then filter (and remove) the 0 records leaving you with the set you describe.

There are a few examples on line of this (invaluable) technique:

http://datapigtechnologies.com/flash...osetables.html
http://datapigtechnologies.com/blog/...-a-pivottable/