No I didn't think about that. Something like:

Select ID, apn, (select permit_1 from #mytable), from #mytable union all

Select ID, apn, (select permit_2 from #mytable), from #mytable....