Convert Transactional Table into table in one step

[rdy4trvl]

The goal is to provide a report of filled volunteer positions. An online web form provides an excel output volunteers and the jobs they selected. The excel consists of one column with the volunteer names and multiple columns of jobs available with the row filled under each job where the volunteer selected that job. So, I'd like a table with two columns - a job (filled) and the associated volunteer name.


The only way I could do this is through multiple query and appends, one for each job. There must be an easier method. Could someone point me in the right direction.
Thanks

[June7]

You are importing or linking to the Excel?

How many possible jobs are there? A UNION query could rearrange the data. There is a limit of 50 lines in a UNION. There is no query designer or wizard for UNION, must type in the SQL view editor of query designer. Also, VBA has issues with UNION queries.

SELECT Volunteer, "Job1" As Job FROM tablename WHERE Not Job1 Is Null
UNION SELECT Volunteer, "Job2" FROM tablename WHERE Not Job2 Is Null
UNION SELECT Volunteer, "Job3" FROM tablename WHERE Not Job3 Is Null
UNION SELECT Volunteer, "Job4" FROM tablename WHERE Not Job4 Is Null
UNION SELECT Volunteer, "Job5" FROM tablename WHERE Not Job5 Is Null;

[rdy4trvl]

Works like a gem! I should have taken that SQL class. Huge thanks!!!