Hey folks, I’m trying to figure something out.

I’ve got an old CSV doc that I’ve integrated. Unfortunately, it’s a mess and I’m only a “enough to get by” kind of Airtable coder. I’m a bit stumped.

So, I’m trying to make a formula that combines multiple cells to make a condensed long text field for mailing addresses (if possible). Unfortunately, many of these individual cells are empty and there are 562 lines of them. There’s no good rhyme or reason as to what is empty, either. Sometimes it’s address 1 and address 2, sometimes there’s a city and state and nothing else, sometimes all of the information is filled out, so making a straight hierarchal system like I’m more used to seeing doesn’t really work.

Example:
IF(address 1, <all the info>, 
  (IF(address 2, <address 2 down>,
    (IF(address 3, <address 3  down>,)))

Here’s my best effort at what I want to do:

Any advice? Thanks in advance!