how do i convert a row of data into a column in another excel wor.
 

I want to convert a row of financial data for individuals into a column. For
example, convert:
Name Jan 2/05 Jan 9/05 Jan 16/05
....... Total
John Smith $5.00 $10.00 $15.00
$30.00

to:
Name John Smith
Jan 2/05 $5.00
Jan 9/05 $10.00
Jan 16/05 $15.00
..
..
..
..
Total $30.00

Can anyone help?

1. Select all data you want to convert.
2. Edit Copy
3 Set the cursor in the place you want to put your data
4 Edit Paste Special Transposition

best regards
Jurek