Combining two columns into one without Power Query Editor

[ExcelMonke]

I need some help with combining two columns into one within my report. I can not use the Power Query Editor for a couple factors, and therefore would like a new column within the same table.

This is a sample of what the current table looks like:

Row Number	ID1	ID2
1	123456
2	456789
3		321456
4
5		654132
6	789456
7		987456

Intended result

Row Number	ID1	ID2	IDCombined
1	123456		123456
2	456789		456789
3		321456	321456
4
5		654132	654132
6	789456		789456
7		987456	987456

I have tried using the concatenate, union, and addcolumn functions however I keep running into errors, including scalar value issues.

Any help is greatly appreciated! 

[jthomson · Accepted solution]

Can you not use something like if column2 = blank then column1 else column2? I'm assuming that there's not instances where there might be data in both columns at the same time that you might need to combine

[ExcelMonke]

Sometimes the simplest solutions stare you in the face 🙂  Thank you!