Use Power Query to Unpivot Data across Multiple Columns
HTML-код
- Опубликовано: 5 сен 2024
- Have you ever received an Excel file that had a table already laid out in a pivot table format, but you wanted to have the source table it came from so you could do more analysis (slicing and dicing). Maybe the format your recieved it in was great for one type of analysis but you wanted it in a proper table format so you could create another pivot table to change stuff to your hearts content. If its a small table performing copy/paste may not be so bad, but if it was a large table or something that happened on a recurring basis, that would get tiring. Plus writing VBA is not your cup of tea. Well here's Power Query to the rescue! By using the unpivot feature in Power Query, this can be done fairly quickly and painlessly. See the video for all the Power Query goodness.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 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 www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~