Forum Discussion
RanHo
Helper V
4 years agoCombine/ Merge data in PBI
Good Day guys! Can someone help me how I can merge or combine 2 different data in a column? example below Thanks in advance!
- 4 years ago
Hi RanHo
You can try this, split a column based on digit and non-digit combinations
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
4 years agoNot applicable
RanHo I'm not following what you're expected output is here - could you please clarify the result you're expecting to see?
RanHo
Helper V
4 years agoAnonymous Sorry Sir, the output I want to achieve is the column "LETTERSV2" wherein the the column "LETTERS" is a raw data. I want to merge the A1, A2 and A3 into A only.