combining two columns into one-Excel 2007
 

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

combining two columns into one-Excel 2007
 

On Jul 5, 10:38 pm, Stephen wrote:
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

Hi Steve,

You could use the concatenate function.
Assuming the date is in cell A1 and the number is in cell B1, in cell
C1 enter the formula :-

=A1 & " " & B1

Hope this helps.
All the Best.
Paul

combining two columns into one-Excel 2007
 

Thanks but 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

"Paul Black" wrote:

On Jul 5, 10:38 pm, Stephen wrote:
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

Hi Steve,

You could use the concatenate function.
Assuming the date is in cell A1 and the number is in cell B1, in cell
C1 enter the formula :-

=A1 & " " & B1

Hope this helps.
All the Best.
Paul

combining two columns into one-Excel 2007
 

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then
highlight C!:C30000 and array enter (i.e., enter with Ctrl+Shift+Enter
instead of just enter)

=ArrayReshape(a1:b15000,30000,1)

Alan Beban

Stephen wrote:
Thanks but 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

"Paul Black" wrote:

On Jul 5, 10:38 pm, Stephen wrote:
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
Hi Steve,

You could use the concatenate function.
Assuming the date is in cell A1 and the number is in cell B1, in cell
C1 enter the formula :-

=A1 & " " & B1

Hope this helps.
All the Best.
Paul