Challenge #366: Three Columns Are a Crowd

[harrame]

Spoiler

[bjkay30]

Spoiler

[dwstada]

my solution

the output looks like the output file but does not look like the screenshotted output in the task - however, this can be easily fixed in the formula if necessary

Spoiler

[Robinvm]

Spoiler

[anayet1988]

Ive done it using a single formula tool

Spoiler

[nikbsa]

Add a formula tool

trim(IIF(IsNull([Address]), '', [Address] + ', ') +
IIF(IsNull([Apt/Unit]), '', [Apt/Unit] + ', ') +
IIF(IsNull([Zip]), '', [Zip]))

[vidyasurendra]

My solution:)

[Gurpartap0710]

Spoiler

I added comma after first two columns( if not empty) ,and then concatenated the three columns. Now if last charcater was "," then last charcter was deleted.

[boglarkalipka]

solved

[trepryor]

Far from perfect, but happy with it being my first intermediate challenge!