For completeness sake, if anyone is following up, here is a formula method
modified from a Peo post back in 2002:

Insert a new column B. Type the Rand() function and copy down.

In C1 type the formula:

=INDEX($A$1:$A$136,MATCH(SMALL($B$1:$B$136,1),$B$1 :$B$136,0))&","&INDEX($A$1:$A$136,MATCH(SMALL($B$1 :$B$136,2),$B$1:$B$136,0))&","&INDEX($A$1:$A$136,M ATCH(SMALL($B$1:$B$136,3),$B$1:$B$136,0))&","&INDE X($A$1:$A$136,MATCH(SMALL($B$1:$B$136,4),$B$1:$B$1 36,0))&","&INDEX($A$1:$A$136,MATCH(SMALL($B$1:$B$1 36,5),$B$1:$B$136,0))&","&INDEX($A$1:$A$136,MATCH( SMALL($B$1:$B$136,6),$B$1:$B$136,0))&","&INDEX($A$ 1:$A$136,MATCH(SMALL($B$1:$B$136,7),$B$1:$B$136,0) )&","&INDEX($A$1:$A$136,MATCH(SMALL($B$1:$B$136,8) ,$B$1:$B$136,0))&","&INDEX($A$1:$A$136,MATCH(SMALL ($B$1:$B$136,9),$B$1:$B$136,0))&","&INDEX($A$1:$A$ 136,MATCH(SMALL($B$1:$B$136,10),$B$1:$B$136,0))

Copy C1, Paste Special:Values in each cell down to C137.


"Louise" wrote:

Hello,

I have been reading everything I can and have not come up with the
solution and I am green to excel. Please assist me with this.

I have a list of 137 cells in A1:A137, each cell has data and none of
the cells are duplicates.

I want to randomly combine 10 of the cells together into B1:B137
separating each piece of data by a comma and repeat down the column so
that I have 137 cells with combined data.

Hope that makes sense?

Any help would be fantastic.

Thanks,

Louise