Forum Discussion
ExcelMonke
2 years agoImpactful Individual
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...
- 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
jthomson
2 years agoSolution Sage
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
2 years agoImpactful Individual
Sometimes the simplest solutions stare you in the face 🙂 Thank you!