How to concatenate all combinations across 4 rows?

[HarveyC]

Hi,

I have four rows of data, and need to export/produce every combination of each of the four rows.

So if I had:

X__A_____B
1__Adam__Smith
2__John___Mclaren

It'd produce every combination possible, i.e. Adam Smith, Adam Mclaren, John Smith and John Mclaren.

I need it to work for four columns however, not just two.

Hope that makes sense. Thanks ever so much in advance for any help

PS: Sorry about the rows/columns title error

[rylo]

Hi

Extremely fixed format but....

Please Login or Register  to view this content.

rylo

[HarveyC]

Thanks Rylo, you've saved a complete stranger a lot of time

[rylo]

Hi

I knew I'd worked out a dynamic way some time ago, but couldn't recall how I did it.

As long as you don't go past column H (only 'cos that is where the output goes), this will expand / contract for the different number of rows / columns. Only restriction is that it takes its boundaries from the first row and the first column.

Also sorts the output which may or may not suit.

rylo

Please Login or Register  to view this content.