PartTran baq help

,

There is a guide in Epicor help on how to do a pivot which I believe is what you want