View Single Post
  #1   Report Post  
MrSkoot99
 
Posts: n/a
Default 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?