How to Split Text in Power Query
Channel: Essential Excel
Date: 2022-02-10

Do you know how to split text OR how to unpivot your data using Power Query?

In this video we take a look at how Power Query can take a previously manual and cumbersome process and turn it into an automated solution.

Even regular users of Excel might not know that Power Query has been available in Excel since 2016! If this is your first time discovering or trying to use Power Query then don't worry, unlike many tools that require you to invest significant time for not much upfront return, even just a little time invested into Power Query will be a significant return immediately!

The problem we look at in this video is being able to split out the contents of 1 column into multiple columns and "unpivoting" those values converting them from columns rows.

Familiar with text to columns? If you use this function regularly, then this video is here to help streamline that function for you even more!

If you are new to the channel or watched out videos before, please consider subscribing and if you enjoy the video don't forget to give it a like!

Instructor Lead Excel Course ► https://essentialexceluk.com/products/master-excel-course

More Tutorials ► https://essentialexceluk.com/blogs/tutorials

#MsExcel #powerquery #tutorial