This actually is a cross table. So why don't you convert it to a straight table using the 'CrossTable(MonthYr,APValue) ' and link it to the main table using the common key.
This way all the fieldNames will come in the 'MonthYr' field ( You can process it further to delete the AP in the string ), and the A/P Value coming as corresponding Value.
The tables should be defined so that the analysis is easy. In this case, using crosstable will provide you a better/easy model, IMHO