How can I divide one column by another in Prism?

You can divide alternating data sets (columns A, B, C...) by the columns adjacent to them (columns D, E, F...) or vice versa. See the section on "Matched Control/Reference Values" here.