Скачать или смотреть Split data in power query: split data from rows to columns using power query

In this excel beginners tutorial we look at POWER QUERY in Excel. Using power query transformations is a powerful way to manager your data and automate an excel spreadsheet to turn column data into rows. Learn how to transform data in power query with this easy example that shows you how to split data in multiple columns into separate rows.

You can also download the file from our Google Drive:
https://drive.google.com/file/d/1_WAJ...

0:00 Introduction
0:42 Example data
1:12 Create a table
1:40 Get data from table
2:20 Transform your data
3:48 Load your data
3:56 Adding new data

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

Check out our other videos and playlists!
Pivot Table playlist:    • Плейлист  

And links to our other Pivot table videos:
Guide to Pivot Tables (with follow along file available):    • Beginners guide to Pivot Tables: learn the...  
Introduction to Pivot Tables:    • Learn Pivot Tables in 7 Minutes | Introduc...  
Issues with PIVOT TABLES - fixing common errors:    • Issues with PIVOT TABLES - fixing common e...  
Pivot Charts: https://www.youtube.com/watch?v=85HYt...