Ask Your Question

zamo's profile - activity

2015-09-12 21:19:46 +0200 received badge  Famous Question (source)
2014-08-23 13:41:04 +0200 received badge  Popular Question (source)
2014-08-23 13:41:04 +0200 received badge  Notable Question (source)
2014-02-12 00:02:05 +0200 asked a question Combinate multiple columns

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!