Combining two columns into one- Excel 2007

[Guest]

I have two columns of information. The first contains the date and the second
contains a number. I want to combine these two into a single column where
the date is the first piece of data and the number is the second, etc. etc.

I have about 15000 sets of data (date and number), so to do this manually
would be out of the question.

Any suggestions for a "novice" programmer?

Thanks
Steve

 

[Guest]

Clarification

What I want to do is insert a blank row every other row, and then
move the data in column b1 down into A2, b2 into A4 etc.

Original worksheet
A B
2/1/2007 45
2/2/2007 49
2/3/2007 60

New Worksheet

A
2/1/2007
45
2/2/2007
49
2/3/2007
60

Steve

 

[Dave Peterson]

You can use a helper column with a formula like:

=text(a1,"mm/dd/yyyy")&"---"&b1
or
=text(a1,"mm/dd/yyyy")&"---"&text(b1,"#,##0.00")

Then fill that range with that formula.

Visit Debra Dalgleish's site to see some tips on how to do quick data entry:
http://www.contextures.com/xlDataEntry01.html

 

[Dave Peterson]

You have an active thread elsewhere.

I have two columns of information. The first contains the date and the second
contains a number. I want to combine these two into a single column where
the date is the first piece of data and the number is the second, etc. etc.

I have about 15000 sets of data (date and number), so to do this manually
would be out of the question.

Any suggestions for a "novice" programmer?

Thanks
Steve