Excel Power Query Tutorial: How to clean up data which is split into two rows

preview_player
Показать описание
This is the worst type of input data to get. Each row has been split into two (or sometimes more) rows. We want those to be combined into a single row. Find out how in this 3 minute video.

Dr. Nitin Paranjape (Office MVP)
Рекомендации по теме
Комментарии
Автор

This should have a proper title other than Excel Power Query.

DanielBula
Автор

I have some horribly formatted data (I believe worse) from a Sage Crystal report. Can I show you?

justinzak
visit shbcf.ru