The following long formula can help you to list all possible combinations of two lists values quickly please do as follows. First let me explain the notation on the left. That means that from a group of n objects we are selecting r of them.
Click to download Kutools for Excel.
The latex_nC_rlatex function may be located under the MATH menu with probability commands. Enter the formula List1. I need to populate the Column C with all the possible combinations of the values in Columns A and B. N - r where n represents the total number of items and r represents the number of items being chosen at a time.