How do I write the formula to replace data that occurs in every 46th
row in col B (for example, in B1, B47, etc) with data that occurs in
every row in Col C (for example, in C1, C2, etc)?