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