Create a Pivot Table without Using the Pivot Table Feature (SORT & UNIQUE)

Pivot Tables are one of those great data analysis tools. But what if you wanted a simple cross tab (aka pivot table) without using the Pivot Table command in the ribbon. You could have done this before with various combinations of commands and use the CTRL+SHIFT+ENTER to create arrays. But in Office 365 there are two dynamic array functions (SORT & UNIQUE) that let you create a cross tab very easily. The UNIQUE function in it self is totally useful and I'll cover it in detail near the end of the vid. 🔔 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.buymeacoffee.com/dough #excel #msexcel #doughexcel -~-~~-~~~-~~-~- Please watch: "Convert Table in a PDF File to Excel" https://www.youtube.com/watch?v=COUOvhbQ4CQ -~-~~-~~~-~~-~-