Get list of unique values from dynamic range

In your example, you should have had 27 (3*3*3) values. As long as each of your source columns (A, B, and C) don't have duplicates within them, then this code should work.

Sub Test()
    Dim i As Long
    Dim j As Long
    Dim k As Long
    Dim r As Long
    
    r = 1
    Cells(r, "E").Value = "Result Column"
    For i = 1 To Cells(Rows.Count, "A").End(xlUp).Row
        For j = 1 To Cells(Rows.Count, "B").End(xlUp).Row
            For k = 1 To Cells(Rows.Count, "C").End(xlUp).Row
                r = r + 1
                Cells(r, "E").Value = Cells(i, "A").Value & Cells(j, "B").Value & Cells(k, "C").Value
            Next k
        Next j
    Next i
End Sub

Basically, this sort of operation is called Caretesian Join.

It can be easily be done using PowerQuery.

Load all 3 ranges to PQ (you can use named range or Excel Table).

To Table1 add custom column = Table2
Then add another custom column = Table3

Expand both custom columns.

Resulting table.
0.JPG

See attached file.

NOTE: You could add additional column to track logic if needed.

I tried your instructions, but when I tried to add Table2 as a custom column to Table1, Excel did not like it. Are there step-by-step instructions, starting from a blank workbook, available anywhere that you would recommend?

maybe like this?

custom.jpg

I did that, and after pressing OK, I get:

Capture.JPG

Thanks - that was a great help.

check here the name of tables then load all to the queries
name of table you should see in workbook queries so use exactly the same name in Custom Column

table.jpg

btw. before load to the queries change headers to A, B and C or to any different not a column1, column1, column1

@Bernie

or watch this one