Thursday, May 27, 2021

3 Ways to Swap Columns in Excel

Swapping or moving columns around in your data set can be a fairly simple exercise. It's a simple step of cut and paste. But if you were to move or re-arranging a data set that has a lot of columns or you're working with someone that wants to see how it looks like this or that (multiple times) it becomes a burden. This video covers three ways to move columns around. The first two are using the mouse and cursor to move it around. The last example uses the newer dynamic array function called SORTBY and gives you an effective and dynamic way to swap columns around and change it effortless through multiple times.

No comments:

Post a Comment