Forum Discussion
Solved
Power Query create Address field from Address1,Address2 and City
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
This is the simple way
There is a better way but it requires the field to be null, not an empty string.
2 Replies
This is the simple way
There is a better way but it requires the field to be null, not an empty string.
Hi,
The screenshot should say it all
