Feb 24, 2011 · 188 I have to do some manual reordering or rows in Excel and cut/paste is too hard to use. I'm looking for something that would enable me to use drag'n'drop or to add some buttons to …

I was reading that article and I really have no idea how to make it work, but you have to create a new column with the suffix part only to sort it correctly (and have that sorting order expanded over the …

Aug 24, 2009 · Is there any simple way to reverse the order of some rows in Excel? I'd rather hoped that there might be a suitable option in Paste Special, as there is for Transpose, but apparently not.

May 17, 2023 · 0 This feels like two separate sets of (related) data, but by keeping them next to each other you will make lots of things harder to do as Excel will assume it is one data range. I suggest …

Apr 16, 2020 · I have a set of excel columns as follows (with n number of rows and columns) I want it to be Sorted and reordered using the group, but I need it to be done using the formula, and not the …

Ive tried using a custom list but Excel limits customs lists to 250 chars and the custom list I would need is 1000+ chars. Is there a way to sort row 1 so that it is in the order of row 2?

Jul 27, 2020 · 0 I want to sort (keep) rows by the same column values. For example, As you can see above, I want to sort the rows by the same (matched) column values of code1 and code2 as follows: …

Is there any way you can tell Excel to sort one spreadsheet to match the order of another spreadsheet? I'm hoping to avoid having to manually reorder the few hundred rows to match.

Dec 4, 2017 · I spend a lot of time moving rows around in Excel, both on the Mac and on Windows. I would like to easily drag an excel row into a new position on a spreadsheet and have the …

Mar 26, 2022 · I want to bring all rows containing the same value together, but without using the Sort functionality. I want to bring the rows containing the next occurrences of a value, immediately after …