Combine/ Merge data in PBI

[RanHo]

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!

[v-xiaotang · Accepted solution]

Hi @RanHo 

You can try this, split a column based on digit and non-digit combinations

https://support.microsoft.com/en-us/office/split-a-column-of-text-power-query-5282d425-6dd0-46ca-95b...

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.

[ebeery]

@RanHo I'm not following what you're expected output is here - could you please clarify the result you're expecting to see?

[RanHo]

@ebeery  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.