How do I take two columns of sequential numbers and insert spaces

C

cmrdjr

I have a spreadsheet with two columns of sequential numbers. I need the
numbers in column A to line up with the matching numbers in column B. Is
there a way to do this automatically in Excel?
 
C

cmrdjr

Column b may have some numbers that column A does not have and visa versa. I
ended up writing a macro to accomplish the task, but would still like to know
if there is an inherent Excel feature to do this task. See example below.
Thanks for your help.

A B
1
2 2
3
4 4
 
F

Frank Kabel

Hi
no there's no built-in feature for this. Except using a macro one may
use some helper columns to sort the data
 
C

cmrdjr

Thanks for your help. Is there any place on Office's site to suggest a new
feature?
 
Top