Merging Columns

[WJ876400]

Hi

I have two columns like below. The main data I want to use is from Column B, however when column B has a blank I want to use the data in the corrosponding cell in column A so I end up with column C. Is this possible, thanks in advance

A	B	C
	Green	Green
	Blue	Blue
	Red	Red
Yellow		Yellow
	Pink	Pink
Black		Black
Purle		Purle
	Orange	Orange

[jthomson · Accepted solution]

In Power Query this is a pretty simple if [column b] <> "" then [column b] else [column a], DAX would be similar

[jinny_le]

Hello - would you have suggestion if i have more than 2 columns? Thanks! 

[WJ876400]

@jthomson  sorry i put this as solved but it is not working. When i put in the "" it doesnt work with the measure

thanks

---

[jthomson]

Maybe try null instead dependent on how exactly your data handles blanks