Question: In our Barney-Jones spreadsheet model, we ran investments across columns and years down rows. Many financial analysts prefer the opposite. Modify the spreadsheet model so that years go across columns and investments go down rows. Run Solver to ensure that your modified model is correct. (We suggest three possible ways to do this, and you can experiment to see which you prefer. First, you could start over on a blank worksheet. Second, you could use the Edit/Copy and then Edit/Paste Special with the Transpose option. Third, you could use Excel's TRANSPOSE function.)