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....

There can only be a maximum of 8 permits per record. There can be more than 8 records per APN in which case the permitnum would equal permit_8 +...