Alphasheet can deduce missing data based on the current data. Steps: 1. Refer to AlphaSheet.Fill 2. In the first parameter, select the complete data 3. In the second parameter, select the column where missing data required 4. Execute