Forum Discussion
Combine/ 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
letters (data) | lettersv2 (output)
Thanks in advance!
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.
3 Replies
- v-xiaotang
Community Support
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.
- AnonymousNot 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
Anonymous 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.