Custom Conditional Column from multiple table

[Fathopes]

Hi All,

Basically I have 3 country column(Country 1,Country 2 and Country 2) like below. How can I write the conditional column in the power query to produce the Country column based on the conditional column on Country 1, Country 2 and Country 3. Kindly please help. 

Country 1	Country 2	Country 3	Country
null	Malaysia	Malaysia	Malaysia
blank	Malaysia	null	Malaysia
Brunei	null	null	Brunei

Thanks and Regards,

Hopes.

[ImkeF · Accepted solution]

reHi @Fathopes ,
you add a column with this forumla

List.Select ( { [Country 1], [Country 2], [Country 3] }, (l) => l <> null and l <> "") {0}

It grabs the first value from the column at is neither null nor blank.