Libreoffice Calc - generate list as combination of multiple columns or cell ranges -

i know if there function in libreoffice calc generate list multiple columns or cell ranges.

assume have following unique data

+------+------+------+ | col1 | col2 | col3 | +------+------+------+ |    1 |    | +    | |    2 | b    | -    | |    3 | c    | *    | |    4 | d    | /    | |    5 | e    |      | |      | f    |      | |      | g    |      | +------+------+------+ 

and want create list of unique rows on sheet, like

+-----+---+---+ | 1   | | + | | 1   | | - | | 1   | | * | | 1   | | / | | 1   | b | + | | 1   | b | - | | ... |   |   | +-----+---+---+ 

so said, take every unique value col3 , combine col2 , col1. if finished, take unique value col2, run through every col3 values , create rows. after that, take next col1 unique value , repeat on again.

as result gain 5*7*4 = 140 unique rows in example.

what if need more columns, more unique properties, etc.. thank you!

there may pure lo calc solution, easy lo base.

1. create table named col1 1 integer field called col1, primary key.
2. create 2 more similar tables col2 , col3 text field type.
3. open tables , add records each.
4. create query in design view includes each of 3 tables, no relationships.

now results of query can moved calc dragging , dropping.