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
|