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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to repeat cell values A1 to B1 and B2, and cell A2 to B3 and B4, etc.
- Thread starter Stevekent
- Start date
jolivanes
Well-known Member
- Joined
- Sep 5, 2004
- Messages
- 2,774
- Office Version
- 2013
- 2007
- Platform
- Windows
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
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,556
- Office Version
- 365
- Platform
- Windows
Duplicate to: How to extract same data twice from one cell in one sheet to two cells of another sheet of the same workbook?
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
Upvote
0
- Status
Similar threads
- Question
