i have cell A1 = 1,0,0,1 cell B1=,1,,-1

I need a formula that would be the equivalent of =update(A1,B1) The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number.

Cell C1 output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

more examples:

A1 = 1,0,0,1 cell B1=,1,,-1 --> 1,1,0,-1

A1 = 10,0,0,1 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,0,01 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,-1,0 cell B1=,1,,-1 --> 10,1,-1,-1

A1 = 10,1,0,1 cell B1=,0,,-1 --> 10,0,0,-1

A1 = 10,0,0,01 cell B1=-1,1,, --> -1,1,0,01

general: A1 = a,b,c,d B1 = e,f,g,h --> make C1 by replacing a with e, b with f... etc, if e,f,g,h are not blanks.

I have cell A1 = 1,0,0,1 cell B1=,1,,-1

I need a formula that would be the equivalent of =update(A1,B1).
The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number.

Cell C1 output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

more examples:

A1 = 1,0,0,1 cell B1=,1,,-1 --> 1,1,0,-1

A1 = 10,0,0,1 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,0,01 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,-1,0 cell B1=,1,,-1 --> 10,1,-1,-1

A1 = 10,1,0,1 cell B1=,0,,-1 --> 10,0,0,-1

A1 = 10,0,0,01 cell B1=-1,1,, --> -1,1,0,01

General: 
A1 = a,b,c,d B1 = e,f,g,h --> make C1 by replacing a with e, b with f... etc, if e,f,g,h are not blanks.

i have cell A1 = 1,0,0,1 cell B1=,1,,-1

I need a formula that would be the equivalent of =update(A1,B1) The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number.

Cell C1 output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

more examples:

A1 = 1,0,0,1 cell B1=,1,,-1 --> 1,1,0,-1

A1 = 10,0,0,1 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,0,01 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,-1,0 cell B1=,1,,-1 --> 10,1,-1,-1

i have cell A1 = 1,0,0,1 cell B1=,1,,-1

I need a formula that would be the equivalent of =update(A1,B1) The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number.

Cell C1 output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

more examples:

A1 = 1,0,0,1 cell B1=,1,,-1 --> 1,1,0,-1

A1 = 10,0,0,1 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,0,01 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,-1,0 cell B1=,1,,-1 --> 10,1,-1,-1

A1 = 10,1,0,1 cell B1=,0,,-1 --> 10,0,0,-1

A1 = 10,0,0,01 cell B1=-1,1,, --> -1,1,0,01

general: A1 = a,b,c,d B1 = e,f,g,h --> make C1 by replacing a with e, b with f... etc, if e,f,g,h are not blanks.

i have cell A1 = 1,0,0,1 cell B1=,1,,-1

I need a formula that would be the equivalent of =update(A1,B1) The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number.

Cell C1 output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

i have cell A1 = 1,0,0,1 cell B1=,1,,-1

I need a formula that would be the equivalent of =update(A1,B1) The numbers between the commas can be any number. I need B1 to replace data in A1 where there is a number.

Cell C1 output: 1,1,0,-1

Note: A1 and B1 will always be in that format, 4 numbers separated by commas.

more examples:

A1 = 1,0,0,1 cell B1=,1,,-1 --> 1,1,0,-1

A1 = 10,0,0,1 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,0,01 cell B1=,1,,-1 --> 10,1,0,-1

A1 = 10,0,-1,0 cell B1=,1,,-1 --> 10,1,-1,-1