How to blend, mingle the filled rows of a spreadsheet?
Idea: Add a temporary column, fill it with =rand(). Sort sheet using this column. Delete temporary column. In case your sheet has formulas, you need to check the option “Update references when sorting range of cells.” in Tools > Options > Calc > General. Make a backup of the file before trying it.
1 Like