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

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents