Import variable Column sheet

[don]

How could I import rows where may have from 1 to x columns

empID (01), taskid(01), taskid(02), taskid(03)
empID (02), taskid(05)
empID (03), taskid(03), taskid(01)

in Access, want to build rows as such:
empID (01), task (01)
empID (01), task (02)
empID (01) task (03)
empID(02) taskid(05)
etc...