CCCPaste

airtable-concatenate 3 fields

IF(
    OR(
        {more1} & {more2} & {more3} = "",
        AND(
            {more1} = "0",
            {more2} = "0",
            {more3} = "0"
        )
    ),
    "",
    CONCATENATE(
        SWITCH({more1}, "0", "", "dupe", "", {more1} & "\n"),
        IF(
            AND(
                SWITCH({more1}, "0", "", "dupe", "") != "",
                SWITCH({more2}, "0", "", "dupe", "") != ""
            ),
            "\n", ""
        ),
        SWITCH({more2}, "0", "", "dupe", "", {more2}),
        IF(
            AND(
                SWITCH({more2}, "0", "", "dupe", "") != "",
                SWITCH({more3}, "0", "", "dupe", "") != ""
            ),
            "\n", ""
        ),
        SWITCH({more3}, "0", "", "dupe", "", "\n" & {more3})
    )
)