How can I convert a 2 rows of titles and corresponding numbers into 2 columns? Rebecca
R Rebecca Aug 19, 2005 #1 How can I convert a 2 rows of titles and corresponding numbers into 2 columns? Rebecca
B Blue Hornet Aug 19, 2005 #3 Select and copy the cells, then Edit / Copy (or Ctrl-C), then Edit / Paste Special / Transpose to the new location. (I think it is possible to overwrite part of the source location, if you want to do that.) Chris
Select and copy the cells, then Edit / Copy (or Ctrl-C), then Edit / Paste Special / Transpose to the new location. (I think it is possible to overwrite part of the source location, if you want to do that.) Chris
