I know I should know this, but how do I turn a row of values into a column of values?
Select and copy the cells in the row. Select the next blank cell below the copied row or select a new blank worksheet. Select 'Edit->Paste Special...' On the displayed dialog check "Transpose" then click OK.
If you have the Multi-Paste button showing in Excel 2003 (The Paste button combined with a drop arrow) you can click that drop arrow to use the transpose paste option directly from the toolbar button.