Combine 2 columns into 1

[zijin_cheng]

I have a very long spreadsheet documenting all drawings required at work, and I need to combine those two columns into one (eg placing all subdrawings into the install drawing column). How do I do that quickly without having to copy and paste one by one? There are never 2 items on the same row, only 1 item so don't have to worry about overwriting

Install drawing
	Sub drawing
	Sub drawing
Install drawing
	Sub drawing
	Sub drawing
	Sub drawing
Install drawing
Install drawing
	Sub drawing
Install drawing
	Sub drawing
Install drawing
Sub drawing
Sub drawing

[AstToTheRegionalMGR]

Assuming your first row that you need to do this is row 2, insert this formula in cell C2:

=IF(A2="",B2,A2)

Press Enter, then single-click on C2 again. Hover over the bottom right corner until your cursor turns into a little black plus sign, then double click. That should automatically insert the formula into every cell to the bottom of your table. If it doesn't, then instead of double clicking, just click, hold, and drag all the way to the bottom of the list.

Hope that helps!

[zijin_cheng]

Assuming your first row that you need to do this is row 2, insert this formula in cell C2:

=IF(A2="",B2,A2)

Press Enter, then single-click on C2 again. Hover over the bottom right corner until your cursor turns into a little black plus sign, then double click. That should automatically insert the formula into every cell to the bottom of your table. If it doesn't, then instead of double clicking, just click, hold, and drag all the way to the bottom of the list.

Hope that helps!

Thank you, that is quite a simple solution. Is there a built in function in excel somewhere that does this or the simpliest way is the formula you shared?

[zijin_cheng]

Assuming your first row that you need to do this is row 2, insert this formula in cell C2:

=IF(A2="",B2,A2)

Press Enter, then single-click on C2 again. Hover over the bottom right corner until your cursor turns into a little black plus sign, then double click. That should automatically insert the formula into every cell to the bottom of your table. If it doesn't, then instead of double clicking, just click, hold, and drag all the way to the bottom of the list.

Hope that helps!

Thank you, that is quite a simple solution. Is there a built in function in excel somewhere that does this or the simpliest way is the formula you shared?

[Richard Buttrey]

Why not just Cut (or copy) the whole of column B, paste it underneath the last item in Column A and sort column A.

[AstToTheRegionalMGR]

That's how I would do it, but Richard Buttrey's solution is good too. Probably might be better if you aren't comfortable using the formula

[AstToTheRegionalMGR]

Assuming your first row that you need to do this is row 2, insert this formula in cell C2:

=IF(A2="",B2,A2)

Press Enter, then single-click on C2 again. Hover over the bottom right corner until your cursor turns into a little black plus sign, then double click. That should automatically insert the formula into every cell to the bottom of your table. If it doesn't, then instead of double clicking, just click, hold, and drag all the way to the bottom of the list.

Hope that helps!