Ready to curb your Power BI skills? Find out more here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

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?

Reader Interactions

Let us know your thoughts...

Table of Contents