You don’t have to copy and sort at the same time, although, you will see online solutions that do so using arrays and other complex solutions–nobody really needs to work that hard.
If you want to keep the original order, copy the data and sort the copy. The simplest solution is to add a column of consecutive values adjacent to the data set and sort by the new column. Reversing a data set isn’t difficult although I’ve seen a lot of convoluted solutions for doing so.
There’s no downloadable demonstration file–you can easily create the simple example data range or use your own data. I’m using Excel 2016 on a Windows 10 64-bit system, but you can use older versions. How to return first and last times from timestamps in Microsoft ExcelĬhecklist: Microsoft 365 app and services deployments on Macs Get Microsoft Office Pro and lifetime access to 5 top apps for $59.99 With that simple task quickly solved, we’ll move on to another seemingly complicated problem–reversing and transposing! More about Software Neither task is difficult, but doing both seems to complicate things, and therefore, you overthink the solution. For instance, in this article, I’ll show you how to move and reverse a data set. Often, a solution is simpler than you first imagine if you break the problem down a bit and apply built-in features in a creative way. For more info, visit our Terms of Use page.
This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Susan Harkins explains how to cut to the chase. Reversing and transposing an Excel data set doesn't have to be a complicated process. How to reverse and transpose Excel data with this powerful but simple solution
0 kommentar(er)
