Forum Discussion

ExcelMonke's avatar
ExcelMonke
Impactful Individual
2 years ago
Solved

Combining two columns into one without Power Query Editor

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...
  • jthomson's avatar
    2 years ago

    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