CHOOSE and IF functions can perform broadcasting during Horizontal Stacking

The sample data includes Supplier Name and Sales Amount information, but the sales amounts are contained in a single cell separated by commas.

The goal is to broadcast the supplier's name according to the number of transactions.

Method 1:

=CHOOSE({1,2},B3,TEXTSPLIT(C3,,", ")) 

Method 2:

=IF({1,0},B3,TEXTSPLIT(C3,,", ")) 

Method 3:

=LET(a,TEXTSPLIT(C3,,", "),HSTACK(IFNA(B3&{""},a),a)) 

For larger datasets, this formula can be incorporated within the REDUCE Function to process each row iteratively.