Forum Discussion
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 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!
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
2 Replies
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
Sometimes the simplest solutions stare you in the face 🙂 Thank you!
