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. Enjoy! Here you can download all the pbix files: SUBSCRIBE to learn more about Power and Excel BI!