Use the Pivot Column Feature in Power Query

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=00ZlGWLAwek

You may be used to using the Pivot Table feature in Excel and there is a similar capability in Power Query. But you may think if it's something I can do in a Pivot Table why would I use it in Power Query. Well...if it something you do on a recurring basis, wouldn't it be nice if it took fewer clicks to do this? That's where Power Query comes in to play because it can semi-automate this process. Once you set it up for the most part all you need to do is just click refresh and it auto-magically updates it. In this video it will use an example of a data set with the first column that could have repeating values like name or invoice number and the second (or later) columns have different values (that represent categories) and a final column with a numeric value. If the goal was to see the invoice and the categories as headers in a table then this video will show how. • 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p • 🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr... • 📚 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 • • Convert Table in a PDF File to Excel • ~-~~-~~~-~~-~

#############################

New on site