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
|