Help with Data sorting - macro?

R

rine9558

I have a block of cells that contain a number or a character or nothing.
I would like to select the cells and organize the numbers into
columns, ignoring the characters. Not all of the rows contain all the
numbers so when a row doesn't have a number the cell in that column
should be blank.
The numbers change each time. Is there a "straighten data" macro out
there somewhere?
Thanks,
Chuck
 
D

DavidP

Chuck
Your message is unclear. Post an example of the data before and the
final result you are trying to achieve

DavidP
 
R

rine9558

Attached is an example of the data sorting I am trying to accomplish.
The actual data are large (100x1000) and the numbers are not always in
ascending/descending order (although most of the time they are).
Thanks for any help,
CHUCK


+----------------------------------------------------------------+
| Attachment filename: example.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=354311|
+----------------------------------------------------------------+
 
Top