Conditional Merge Columns

Power Query
1

Hi All,

Wondering if someone can assist me with my PowerQuery question. I have a table which I am wanting to conditionally merge and remove the original columns in a single step.

Original

image

Merged:
image

= Table.CombineColumns(Source,{"Letter", "Alt Letter"},Combiner.CombineTextByDelimiter(" ", QuoteStyle.None),"Merged")

Expected:

image

I’m trying to use the above Power Query expression based on the conidtion merge only if [Letter] <> [Alt Letter} else [Letter]

Thanks

2

Hey @adsa
I broke it into 2 steps. Please see the attached PBX
image
merge.pbix (26.9 KB)
hope that helps

3

@jsodhi

Thanks that worked

1 Like