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.

SUBSCRIBE to my channel https://goo.gl/wN3c3p

Excel Training https://www.exceltraining101.com/p/training.html

Excel Books & Tech Gear https://www.amazon.com/shop/dough

️ Tools: Screencasting https://techsmith.z6rjha.net/5Qe53

️ Tools: Microsoft Office https://microsoft.msafflnk.net/rKL0G

️ Tools: TubeBuddy https://www.tubebuddy.com/et101

This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

If you find these videos useful and want to support my channel go to https://www.patreon.com/DoughExcel

#excel
#msexcel
#doughexcel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.