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: • 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...
In questa pagina del sito puoi guardare il video online Split data in power query: split data from rows to columns using power query della durata di online in buona qualità , che l'utente ha caricato Bitesize Excel 26 aprile 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 408 volte e gli è piaciuto 14 spettatori. Buona visione!
