Combinate multiple columns [closed]

asked 2014-02-12 00:02:05 +0200

zamo gravatar image

Hello everybody.

I am new in LibreOffice world and my research is not going anywhere, please help me with my task below:

I have 3 colums with different data and different sizes, I would like to get in 3 different columns all the combinations possible, for example:

INPUT:

-A-- B-- C--

| 1 | A | dog |

| 2 | B | cat |

| 3 | --- | --- |

OUTPUT:

-A-- B-- C--

| 1 | A | dog |

| 1 | A | cat |

| 1 | B | dog |

| 1 | B | cat |

| 2 | A | dog |

| 2 | A | cat |

| 2 | B | dog |

| 2 | B | cat |

| 3 | A | dog |

| 3 | A | cat |

| 3 | B | dog |

| 3 | B | cat |

As you can see the output can be pretty big, so I want to automate all the manual work of copy/paste, is there any tool like Macros, VB or similar that you could point me to accomplish this goal?

Any assistance will be appreciated!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-19 09:58:38.143268