How to repeat cell values A1 to B1 and B2, and cell A2 to B3 and B4, etc. Example, A1 value is cat and A2 is dog, and now I want B1 to be cat, B2 also cat, and B3 and B4 to be dog. As I’ve a long list, I need a formula to easily accomplish the task. Please help. Thank you in advance.