I hope I can explain this  . . .

I have several fields that can be null and I need to concatenate them
together to create a single value.  Not my data, so please understand it
follows no logical rules.

Here are the fields:

Combined1: Null
Element2: Null
Combined2: 1111
Element3: 2222
Combined3: Null
Element4: 3333
Combined4: Null
Element5: Null
Combined5:Null

Each data piece needs to be separted by a semi-colon.  The issue is handling
all of the different combination of nulls.  Any field can be null.

The final result would be:

1111; 2222; 3333

If I had:

Combined1: 9999
Element2: Null
Combined2: Null
Element3: Null
Combined3: Null
Element4: Null
Combined4: Null
Element5: Null
Combined5:Null

Result:

9999

Thanks!

How to concatenate strings from a column into a single row (with NULL value)?
xp_cmdshell - works with string in one format but not in another -
Query help
Single to Multiple columns
Assistance with SQL Script