2. In Column B add random number by inserting the formula =Rand () in
each row up to Column A values [B1 to B10].
3. Select the Both Column
4. In Menu Bar, go to Data>Sort.
5. Sort by Column B, where by the random numbers
You will get the random series values from A1 to A10 in Excel