Combine multiple Address field columns from the same table

[reportuser]

Hello,

I have 4 address columns in the same table namely Address1, Address2, City, and zipcode. I need to merge it into 1 column, so far I have tried

Formula 1:
Address = [Address1] & "," & IF(ISBLANK([Address2]),[city]) & "," & [zipcode]

Formula 2:
Address = [Address1] & "," & IF(ISBLANK([Address2]),[city]),IF(ISBLANK([city]),[zipcode]))

Format required
Address = Address1,Address2,city,zipcode

If any these columns are (null) then it would should output something like this
Address = Address1,city,zipcode

Any help would be appreciated.

[amitchandak]

@reportuser , try like

Address = [Address1] & IF(ISBLANK([Address2]), "," & [Address2] ) & IF(ISBLANK([city]), "," & [city] ) & IF(ISBLANK([zipcode]), "," & [zipcode] )

[reportuser]

@amitchandak- I'm sorry that did not work and you can find the output below

Address = [Address1] & "," & [Address2] & "," & [city] & "," & [zip]

Output = Address1,Address2,city,zip

Address = [Address1] & IF(ISBLANK([Address2]), "," & [Address2] ) & IF(ISBLANK([city]), "," & [city] ) & IF(ISBLANK([zipcode]), "," & [zipcode] )

Output = Address1

[amitchandak · Accepted solution]

@reportuser , Sorry my mistake not is missing

Address = [Address1] & IF(not(ISBLANK([Address2])), "," & [Address2] ) & IF(not(ISBLANK([city])), "," & [city] ) & IF(not(ISBLANK([zipcode])), "," & [zipcode] )