Python program to transform an Excel document, with some parsing
Using pandas you can do it in much simpler way. 
Steps: 
1. Load the data in pandas dataframe from your excel sheet - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html 
2. Filter out the columns which you want to keep (you can specify the column names to be loaded while importing in step 1 also) 
3. Transform the columns based on your requirement 
4. Delete the rows which are null, in your case as it is H7 using pandas function dropna() - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.dropna.html 
5. Export the data to an excel sheet - https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_excel.html 

For your reference, refer this blog- https://towardsdatascience.com/replacing-excel-with-python-30aa060d35e