How to repeat cell values A1 to B1 and B2, and cell A2 to B3 and B4, etc.

Status
Not open for further replies.

Stevekent

Board Regular
Joined
Jul 24, 2013
Messages
109
Office Version
  1. 365
Platform
  1. Windows
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
You ought to let people now that you have this request in another forum also (have a hyperlink to it here) and that you have not answered a request from a helper who, in my opinion, is the person that can help you.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top