New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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.

Table of contents:

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

Watch the tutorial:

Split multiple columns into rows without errors in Power Query
Was this helpful?
Previous Import tables or pages based on a word or phrase from a pdf in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents