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

On Jul 5, 10:38 pm, Stephen <Step...@discussions.microsoft.com> 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

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 <Step...@discussions.microsoft.com> 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
>
>

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 <Step...@discussions.microsoft.com> 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
>>
>>