Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combing 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combing two columns into one- Excel 2007
On Jul 5, 2:40 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 Assuming the data is in columns A & B, use =CONCATENATE(A1, " ", B1). Copy it down to all 15000 rows. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combing 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 "Tim Shnell" wrote: On Jul 5, 2:40 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 Assuming the data is in columns A & B, use =CONCATENATE(A1, " ", B1). Copy it down to all 15000 rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 rows & columns | Excel Discussion (Misc queries) | |||
more than 255 columns in excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Insert Columns | Excel Worksheet Functions | |||
Number of Excel 2007 Columns | Excel Discussion (Misc queries) | |||
Formula Help Combing two AND statements | Excel Worksheet Functions |