Have you considered using a dynamic VBA solution to populate the formula across the destination row, given the variable number of values in the source data?