Description:
When using TEXTJOIN with a constant array for the delimiters and ignore_empty is set true the delimiter picked from the constant array is not advanced when an empty cell/field is encountered which desynchronizes the multiple delimiters from their obviously intended purpose to represent data hierarchy (to distinguish fields and fields from records).

Steps to Reproduce:
Enter TEXTJOIN like =TEXTJOIN({",",",",";"},1,F9:H11) either as part of a CSE/array formula or just a normal cell formula.

Actual Results:
With range fully populate behaviour is as expected, like

1	a	A
2	b	B
3	c	C
		
TextJoin:	1,a,A;2,b,B;3,c,C	

With any empty cell, the delimiters blindly repeat in cycle and become meaningless, like:

1		A
2	b	B
3	c	C
		
TextJoin:	1,A,2;b,B,3;c,C	

Expected Results:
The expected result would be:

1		A
2	b	B
3	c	C
		
TextJoin:	1,A;2,b,B;3,c,C	


Reproducible: Always


User Profile Reset: No



Additional Info:
I do not have access to MS Excel 2019, but https://support.office.com/en-us/article/TEXTJOIN-function implies that TEXTJOIN is meant to be able to distinguish data fields from data records, etc.

Version: 6.4.3.2
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded