View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default how do I transpose a column of 80 numbers into...

One option is create a first row of formulas with =A1, =A11, =A21, ..., =A71,
and copy/paste on the 10 rows.

Hope this helps,
Miguel.

"beatrice25" wrote:


...10 rows of 8 cells

Any ideas

Many thanks

Beatrice


--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505
View this thread: http://www.excelforum.com/showthread...hreadid=543812