View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default How to get these cells into 1 column

Select the first row, copy, paste special, transpose.

Repeat for all rows.

Depending on how many rows you need to do that to you may need to write a
macro to automate the process.
--
Brevity is the soul of wit.


"Chris" wrote:

Okay that post was butchered up. Here's what it should look like.

0 25 50 75 100
125 150 175 200 225
250 275 300 325 350

Here's what I want:
0
25
50
75
100
...etc

"Chris" wrote:

Any ideas how to get this format of numbers into 1 column?

0 25 50 75 100 I would like this: 0
125 150 175 200 225
25
300 325 350 375 400
50

75.....etc