Home

Intentionally Duplicating Data

%3CLINGO-SUB%20id%3D%22lingo-sub-741602%22%20slang%3D%22en-US%22%3EIntentionally%20Duplicating%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741602%22%20slang%3D%22en-US%22%3EI%20have%20a%20list%20of%20data%20in%20column%20B%3CBR%20%2F%3E%3CBR%20%2F%3EI'd%20like%20every%20cell%20in%20column%20B%20repeated%20twice%20in%20column%20A%3CBR%20%2F%3E%3CBR%20%2F%3EE.g.%3CBR%20%2F%3EA1%3DB1%3CBR%20%2F%3EA2%3DB1%3CBR%20%2F%3EA3%3DB2%3CBR%20%2F%3EA4%3DB2%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20tried%20typing%20this%20in%20this%20simply%20and%20using%20auto%20fill%20but%20auto%20fill%20always%20interprets%20as%20the%20cell%20to%20the%20right%20i.e.%20A3%3DB3%20meaning%20B2%20data%20is%20lost%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20formula%20that%20I%20can%20use%20instead%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-741602%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741691%22%20slang%3D%22en-US%22%3ERe%3A%20Intentionally%20Duplicating%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741691%22%20slang%3D%22en-US%22%3ETry%20this%20formula%20in%20A1%2C%20copied%20down%20rows%3A%3CBR%20%2F%3E%3DINDEX(B%3AB%2C%3CBR%20%2F%3ECEILING(ROW(B1)%2F2%2C1))%3C%2FLINGO-BODY%3E
Highlighted
AdamBroom
Occasional Visitor
I have a list of data in column B

I'd like every cell in column B repeated twice in column A

E.g.
A1=B1
A2=B1
A3=B2
A4=B2

Have tried typing this in this simply and using auto fill but auto fill always interprets as the cell to the right i.e. A3=B3 meaning B2 data is lost

Is there a formula that I can use instead?
1 Reply
Try this formula in A1, copied down rows:
=INDEX(B:B,
CEILING(ROW(B1)/2,1))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies