Here below is a data table, in which the data are separated by commas:

Now we want to list the permutations and combinations of these data, one combination per row, as shown in the following figure:

Enter in cell A2:

A1: Split the data in each cell with comma, and the option @c means splitting with comma
A2: Loop through each member of A1 and concatenate them into a string A1(1);A1(2);A1(3)
A3: Convert the string concatenated in A2 to the parameter of the function xjoin in macro form, that is, perform full cross-product on the sequences formed by split data in each cell
 

esProc Desktop and Excel Processing
14.10 Expand into multiple N-column horizontally
15.1 Split string - separate by comma – automatic parsing of data type