Power Query create Address field from Address1,Address2 and City

[MikeSolvesBI]

Hello,

I need to create a new Address field from Address1,Address2 & City. 

Sometimes Address2 is Null,

I am using a Custom Column.

What is the best way to handle this so that I can have

Address: 111 Main street

Address2: NULL

City: Summit

Field: 111 Main Street, Summit

Or

Address: 111 Main Street

Address2: Suite 100

City: Summit

111 Main Street, Suite 100, Summit

Thank You,

Michael

[Ashish_Mathur]

Hi,

The screenshot should say it all

[lbendlin · Accepted solution]

This is the simple way

There is a better way but it requires the field to be null, not an empty string.