Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
I need to merge two columns, A & B, and only B has data which I
obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
So A and B have Data and B has precidence ?
Create a helper column C with c1 =if(b1<"",b1,a1) Otherwise explain what you meant with the A1 & B1 Steve On Thu, 25 Jan 2007 04:47:24 -0000, michaelberrier wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
Column A has no data, B is populated.
I need to merge the two and preserve the data in B. Obviously, I could do this one at a time, but I tried to expedite by merging A1 & B1, then tried filling down by copying the merged A1 and filling down with a Paste Special --Formats, but this gives me blank, merged cells. Is that better? Thanks On Jan 24, 10:58 pm, SteveW wrote: So A and B have Data and B has precidence ? Create a helper column C with c1 =if(b1<"",b1,a1) Otherwise explain what you meant with the A1 & B1 Steve On Thu, 25 Jan 2007 04:47:24 -0000, michaelberrier wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
Its 5am in the morning here, so forgive me.
By Merge you mean Cell merge A and B Select cells A1 and B1, Format Cell - Merge Result A1/B1 merged with value as in B1 Drag down as required. Works for me. Only problem is if Column A has data, but you said it was empty Steve On Thu, 25 Jan 2007 05:02:41 -0000, michaelberrier wrote: Column A has no data, B is populated. I need to merge the two and preserve the data in B. Obviously, I could do this one at a time, but I tried to expedite by merging A1 & B1, then tried filling down by copying the merged A1 and filling down with a Paste Special --Formats, but this gives me blank, merged cells. Is that better? Thanks On Jan 24, 10:58 pm, SteveW wrote: So A and B have Data and B has precidence ? Create a helper column C with c1 =if(b1<"",b1,a1) Otherwise explain what you meant with the A1 & B1 Steve On Thu, 25 Jan 2007 04:47:24 -0000, michaelberrier wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
Insert a column to the right of B
Select B1 and C1 and merge them which preserves data from B Select that merged cell and double-click on the format paintbrush. Select B2 and C2 and drag down B and C as far as you wish. Click once on paintbrush to end formatting. Delete Column A. Gord Dibben MS Excel MVP On 24 Jan 2007 20:47:24 -0800, "michaelberrier" wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
But when I drag down that way, I just end up with either empty cells or
a fill down of whatever is in A1/B1. I need to preserve the data that is in B2, B3, so on... Sorry if I wasn't clear. On Jan 24, 11:12 pm, SteveW wrote: Its 5am in the morning here, so forgive me. By Merge you mean Cell merge A and B Select cells A1 and B1, Format Cell - Merge Result A1/B1 merged with value as in B1 Drag down as required. Works for me. Only problem is if Column A has data, but you said it was empty Steve On Thu, 25 Jan 2007 05:02:41 -0000, michaelberrier wrote: Column A has no data, B is populated. I need to merge the two and preserve the data in B. Obviously, I could do this one at a time, but I tried to expedite by merging A1 & B1, then tried filling down by copying the merged A1 and filling down with a Paste Special --Formats, but this gives me blank, merged cells. Is that better? Thanks On Jan 24, 10:58 pm, SteveW wrote: So A and B have Data and B has precidence ? Create a helper column C with c1 =if(b1<"",b1,a1) Otherwise explain what you meant with the A1 & B1 Steve On Thu, 25 Jan 2007 04:47:24 -0000, michaelberrier wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
That is precisely what I needed, thanks Gord and Steve!
On Jan 24, 11:16 pm, Gord Dibben <gorddibbATshawDOTca wrote: Insert a column to the right of B Select B1 and C1 and merge them which preserves data from B Select that merged cell and double-click on the format paintbrush. Select B2 and C2 and drag down B and C as far as you wish. Click once on paintbrush to end formatting. Delete Column A. Gord Dibben MS Excel MVP On 24 Jan 2007 20:47:24 -0800, "michaelberrier" wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging two columns, data in one
I see you've got it working
Thanks for the feedback On Thu, 25 Jan 2007 05:18:04 -0000, michaelberrier wrote: But when I drag down that way, I just end up with either empty cells or a fill down of whatever is in A1/B1. I need to preserve the data that is in B2, B3, so on... Sorry if I wasn't clear. On Jan 24, 11:12 pm, SteveW wrote: Its 5am in the morning here, so forgive me. By Merge you mean Cell merge A and B Select cells A1 and B1, Format Cell - Merge Result A1/B1 merged with value as in B1 Drag down as required. Works for me. Only problem is if Column A has data, but you said it was empty Steve On Thu, 25 Jan 2007 05:02:41 -0000, michaelberrier wrote: Column A has no data, B is populated. I need to merge the two and preserve the data in B. Obviously, I could do this one at a time, but I tried to expedite by merging A1 & B1, then tried filling down by copying the merged A1 and filling down with a Paste Special --Formats, but this gives me blank, merged cells. Is that better? Thanks On Jan 24, 10:58 pm, SteveW wrote: So A and B have Data and B has precidence ? Create a helper column C with c1 =if(b1<"",b1,a1) Otherwise explain what you meant with the A1 & B1 Steve On Thu, 25 Jan 2007 04:47:24 -0000, michaelberrier wrote: I need to merge two columns, A & B, and only B has data which I obviously want to preserve. I have tried merging A1 & B1 and doing a "Paste Special" for the rest of the column, but it leaves me with a blank, merged cell. How can I make this into a single column while preserving the data I already have? Thanks to all -- Steve (3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
summing columns if there is data | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |