Well, I don't see a way to do this in one easy step.  So, I would load the AS400 data into a staging table.

From the staging table, you may need to then populate another table that crosstabs the data from the original staging table.  Then, you can query from that to populate the final destination table.

Hope this helps.