Bad Data to Good Data: Filling in gaps using Power Query

This is a continuation of a series on how to convert badly formatted data into an easy to analyze – tabular format. In this article, we are talking about data which has gaps and how to fill them efficiently. This is a new approach available using Power Query – it is fast and effective. Have a look and save hours of your precious time.

image

Continue reading