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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
does column b contain more or less items/values than column A?
 
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
 
Hi
no there's no built-in feature for this. Except using a macro one may
use some helper columns to sort the data
 
Thanks for your help. Is there any place on Office's site to suggest a new
feature?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sequentially numbered column that resets with each new sample 0
Sequential numbering when X column repeats records 3
Row Numbering 8
Auto update row numbers after inserting new row 4
Use validation for (sometimes) sequential number list 1
Automaticalle generate sequential reference number 2
'Trick' to restore original sort order after data modified? 3
Automatic Sequential numbers 7

Back
Top