Any way of shuffilng a slice of a loop table?
Does anyone know of a way to shuffle a slice within a loop? So, for example in a table, I have a column with the numbers 1 to 10. I want to mix up the numbers 1 to 5, and the numbers 6 to 10, but not simply mix all 10 numbers. In other words, the numbers will be randomised, but all the numbers below 6 will be somewhere in the first five rows, and likewise, numbers 6 and above will all be in rows 6 to 10.
Alternatively, is it possible to shuffle two colums identically (from a table containing, say, 4 columns) so that the pairs of items (one from each column) stay 'matched up'. So, if I have four columns, one contains A through to Z, and another contains 1 to 26, I can rearrange them randomly, but the row in the first column containing the letter A will still correspond to the row containing the number 1 in the second column and so on. The other two columns would stay in their original order.
Any advice gratefully welcommed!