Microsoft
Tech Community
Home
Community Hubs
Community Hubs
Community Hubs Home
Products
Special Topics
Video Hub
Close
Products
(50)
Special Topics
(27)
Video Hub
(462)
Most Active Hubs
Microsoft 365
Microsoft Teams
Windows
Outlook
Security, Compliance and Identity
SharePoint
Azure
Windows Server
Exchange
Intune and Configuration Manager
Microsoft Edge Insider
OneDrive
Microsoft Viva
Connect and learn from experts and peers
Microsoft FastTrack
Best practices and the latest news on Microsoft FastTrack
Microsoft Sales Copilot
A role-based copilot designed for sellers
Most Active Hubs
Education Sector
ITOps Talk
AI and Machine Learning
Microsoft Mechanics
Microsoft Partner Community
Healthcare and Life Sciences
Internet of Things (IoT)
Public Sector
Mixed Reality
Small and Medium Business
Startups at Microsoft
Azure Partner Community
Expand your Azure partner-to-partner network
Microsoft Tech Talks
Bringing IT Pros together through In-Person & Virtual events
MVP Award Program
Find out more about the Microsoft MVP Award Program.
Video Hub
Azure
Exchange
Microsoft 365
Microsoft 365 Business
Microsoft 365 Enterprise
Microsoft Edge
Microsoft Outlook
Microsoft Teams
Security
SharePoint
Windows
Blogs
Blogs
Events
Events
Events Home
Microsoft Ignite
Microsoft Build
Community Events
Microsoft Learn
Microsoft Learn
Home
Community
Blog
Azure
Dynamics 365
Microsoft 365
Security, Compliance & Identity
Power Platform
Github
Teams
.NET
Lounge
Lounge
1.4M
Members
11.6K
Online
328K
Discussions
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Sign In
Sign In
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Show
only
|
Search instead for
Did you mean:
Home
Home
Microsoft 365
Excel
Intentionally Duplicating Data
Intentionally Duplicating Data
Discussion Options
Subscribe to RSS Feed
Mark Discussion as New
Mark Discussion as Read
Pin this Discussion for Current User
Bookmark
Subscribe
Printer Friendly Page
AdamBroom
Copper Contributor
Jul 07 2019
03:09 PM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Jul 07 2019
03:09 PM
Intentionally Duplicating Data
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?
Labels:
Labels:
Excel
Formulas and Functions
All Discussions
Previous Discussion
Next Discussion
1 Reply
Twifoo
replied to
AdamBroom
Jul 07 2019
07:16 PM
Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Report Inappropriate Content
Jul 07 2019
07:16 PM
Re: Intentionally Duplicating Data
Try this formula in A1, copied down rows:
=INDEX(B:B,
CEILING(ROW(B1)/2,1))
Browse