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...
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