Split multiple columns into rows without errors in Power Query

Sometimes when reading PDF files in power query, the tables created with get multiple rows into one on all columns, and the split function in power query does not work to split them.

In todays video, I will show you how to split multiple columns into rows in one step and how to avoid errors depending on how the data gets imported.

Chapter:
00:00 Explain use case
00:30 Split columns into rows with the UI, the wrong way
01:00 Split Columns with Table.Split
02:00 Split multiple columns into rows in one step
03:50 Manage errors that might occur

Enjoy!

Here you can download all the pbix files: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

https://curbal.com/product/sponsor-me

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲


************





************


QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB

#CURBAL #SUBSCRIBE