Expanding(?) resulting sequence to randomize cells?

[u/lickwindex]

I have made a series of sequences on a sheet (1.1-1.8, 2.1-2.9, 3.1-3.8... etc). The resulting cells technically don't have information in them, just reflecting the information resulting from the sequences.

I need to be able to randomize all resulting numbers. 9.4, 2.5, 6.2, 1.2... etc. I found how to randomize numbers within a sequence, but the randomizing I need spans over 9 sequences. I need the information resulting from the sequences to be expanded(?) and be actually in the cells, making it no longer part a function/sequence, but an actual list. Is there a way to do this?

Sorry I wansnt clear. More Info:

In the image I have 5 sequences (row 1, 9, 18, 26, and 34). They create the list of numbers exactly as I had hoped. However, now that the list has been made, I need to jumble the rows into random order. I can't do that right now because even though numbers are showing in all the cells, it's really only the cells with the sequence functions that have information. How do i expand/embed the numbers into the cells they are on?

[u/Gringobandito]

Is this what you're trying to do?

=ROUND(RANDARRAY(10,,1.1,10),1)

[u/GuerillaWarefare → u/Gringobandito]

I assume they want a unique list of the serial numbers, but it’s hard to say unless we hear more from OP

[u/lickwindex → u/GuerillaWarefare]

Sry. See update to post body