move list of numbers from one column to multiple columns

[Guest]

How do I move a list of 15000 numbers from one column to 6 or 8 to make it
easier to display.

 

[Guest]

cut and paste?

 

[mphell0]

What do your numbers look like now and how do you want them to look?

 

[Guest]

15000 numbers, I was looking for an automated process

 

[Guest]

15000 telephone numbers. I want them to be in 6 or 8 columns, instead of 1

 

[mphell0]

You're going to have to give more details. Can you give an example o
what
you are trying to do? What part of the number would go into anothe
column

 

[mphell0]

If you have a number like 1-123-456-7890 and you want it to be

1 in a column
123 in another
456 in another
7890 in another

You can use Data->Text to columns selected delimited and fo
delimiters
select other and enter "-

 

[Guest]

I have imported a file of telephone numbers. There are 15,000 numbers in a
single column. If I printed or displayed the numbers, I would only see 60
(or so)per page. I would like to move spread those 15,000 telephone numbers
in multiples columns. So when I run a report, I have numbers in 6 or 8
columns rather than one. Purely for printing and display.

 

[vezerid]

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

 

[Guest]

You could do something like this. Since 15000/6 = 2500, you could hit Cntl-g
(for goto, type the range a2500:a5000 (or something very similar) hit cntl-x
(for cut,)
then right arrow end up (hopefully you will now be in b1,) and cntl-v for
paste. Repeat the process going from, for instance a5001:a7500 (or
thereabouts.) When finished doing all 6 (or 8) columns, go down to row 2500.
Hold shift and then hit cntl-end to go to the bottom of your spreadsheet,
right click and hit delete and answer entire row. Then save (this should
make it so Excel doesn't think your used range is as far down as it was
originally.)

 

[Guest]

Thank you. I will try that.

 

[Guest]

Thanks. Someone else gave me an automated way. See vezerid

 

[Guest]

thank you. Someone gave me another. See vezerid I will try them all.