Complete the gaps – complete a column of numbers

Background

Skillname
55%
Skillname
55%
Skillname
55%

I had a large sheet with over 100,000 rows – but there were gaps in this data in the form of missing rows. I had to identify the missing rows and generate an exceptions sheet with this data; I also had to create a row in the raw data in the form of a placeholder.

 

Solution

A macro was the simplest solution, by providing the expected pattern, it could identify any gaps, and then add that ID number on to a second sheet, and generate the missing rows.

 

Verification

The data was then checked against a formula-only solution that verified that the pattern generated by the macro was correct and that every new blank row was indeed an exception.