It is common to want to transform data to perhaps change units or convert to logarithms. On a spreadsheet you can transform right on the same table. Not with Prism. To transform you choose the Transform analysis which puts the results on a new Results table and leaves the data alone.
Similarly, choose a specialized analysis to Normalize, Transpose, or Remove a baseline.