View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
coach eo
 
Posts: n/a
Default move list of numbers from one column to multiple columns

Thank you. I will try that.

"vezerid" wrote:

Do the following:

Decide on the number of columns that you want. Let us say you want 6
columns. In the row put the numbers 0...5 (a total of 6 numbers)

Assuming you want your transferred data to start from row 2, below the
0, use the following formula:

=OFFSET($A$2,(ROW()-2)*6+D$1,0)

In this formula, we assume your phone numbers start from A2, that you
have 6 columns and that the 0...5 start from D1. Copy as far down and
across as necessary.

HTH
Kostis Vezerides