How to paste sparse columns so they line up with existing data?
So, I have a spreadsheet with about 5000 rows.
Each of these rows has a unique number in column A, followed by some data in column B:
| A | B |
|-------|------------|
| 5142 | Test |
| 5348 | Some stuff |
| 32665 | More stuff |
| 74568 | More stuff |
In another spreadsheet, I have some different data, for SOME of the IDs in my first spreadsheet, but not all of them:
| A | B |
|-------|-----------|
| 5348 | 1/1/2017 |
| 74568 | 6/25/2018 |
What I want to do is copy these columns from the second spreadsheet into the first spreadsheet, but I need the rows to spread out to paste into the corresponding rows from spreadsheet 1, so what I end up with is this:
| A | B | C | D |
|-------|------------|-------|-----------|
| 5142 | Test | | |
| 5348 | Some stuff | 5348 | 1/1/2017 |
| 32665 | More stuff | | |
| 74568 | More stuff | 74568 | 6/25/2018 |
Any idea how I can accomplish this?
microsoft-excel microsoft-excel-2016 copy-paste paste
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
add a comment |
So, I have a spreadsheet with about 5000 rows.
Each of these rows has a unique number in column A, followed by some data in column B:
| A | B |
|-------|------------|
| 5142 | Test |
| 5348 | Some stuff |
| 32665 | More stuff |
| 74568 | More stuff |
In another spreadsheet, I have some different data, for SOME of the IDs in my first spreadsheet, but not all of them:
| A | B |
|-------|-----------|
| 5348 | 1/1/2017 |
| 74568 | 6/25/2018 |
What I want to do is copy these columns from the second spreadsheet into the first spreadsheet, but I need the rows to spread out to paste into the corresponding rows from spreadsheet 1, so what I end up with is this:
| A | B | C | D |
|-------|------------|-------|-----------|
| 5142 | Test | | |
| 5348 | Some stuff | 5348 | 1/1/2017 |
| 32665 | More stuff | | |
| 74568 | More stuff | 74568 | 6/25/2018 |
Any idea how I can accomplish this?
microsoft-excel microsoft-excel-2016 copy-paste paste
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
4
Use VLOOKUP()..
– Scott Craner
Jan 8 at 0:17
add a comment |
So, I have a spreadsheet with about 5000 rows.
Each of these rows has a unique number in column A, followed by some data in column B:
| A | B |
|-------|------------|
| 5142 | Test |
| 5348 | Some stuff |
| 32665 | More stuff |
| 74568 | More stuff |
In another spreadsheet, I have some different data, for SOME of the IDs in my first spreadsheet, but not all of them:
| A | B |
|-------|-----------|
| 5348 | 1/1/2017 |
| 74568 | 6/25/2018 |
What I want to do is copy these columns from the second spreadsheet into the first spreadsheet, but I need the rows to spread out to paste into the corresponding rows from spreadsheet 1, so what I end up with is this:
| A | B | C | D |
|-------|------------|-------|-----------|
| 5142 | Test | | |
| 5348 | Some stuff | 5348 | 1/1/2017 |
| 32665 | More stuff | | |
| 74568 | More stuff | 74568 | 6/25/2018 |
Any idea how I can accomplish this?
microsoft-excel microsoft-excel-2016 copy-paste paste
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
So, I have a spreadsheet with about 5000 rows.
Each of these rows has a unique number in column A, followed by some data in column B:
| A | B |
|-------|------------|
| 5142 | Test |
| 5348 | Some stuff |
| 32665 | More stuff |
| 74568 | More stuff |
In another spreadsheet, I have some different data, for SOME of the IDs in my first spreadsheet, but not all of them:
| A | B |
|-------|-----------|
| 5348 | 1/1/2017 |
| 74568 | 6/25/2018 |
What I want to do is copy these columns from the second spreadsheet into the first spreadsheet, but I need the rows to spread out to paste into the corresponding rows from spreadsheet 1, so what I end up with is this:
| A | B | C | D |
|-------|------------|-------|-----------|
| 5142 | Test | | |
| 5348 | Some stuff | 5348 | 1/1/2017 |
| 32665 | More stuff | | |
| 74568 | More stuff | 74568 | 6/25/2018 |
Any idea how I can accomplish this?
microsoft-excel microsoft-excel-2016 copy-paste paste
microsoft-excel microsoft-excel-2016 copy-paste paste
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
asked Jan 8 at 0:14
Sean WorleSean Worle
12715
12715
4
Use VLOOKUP()..
– Scott Craner
Jan 8 at 0:17
add a comment |
4
Use VLOOKUP()..
– Scott Craner
Jan 8 at 0:17
4
4
Use VLOOKUP()..
– Scott Craner
Jan 8 at 0:17
Use VLOOKUP()..
– Scott Craner
Jan 8 at 0:17
add a comment |
1 Answer
1
active
oldest
votes
set cell C to:
=vlookup(A1,sheet2!A:B,1,FALSE)
and cell D to:
=vlookup(A1,sheet2!A:B,2,FALSE)
Where your data in sheet 2 is in columns A and B.
answered Jan 8 at 23:06
BrianBrian
3475
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1391716%2fhow-to-paste-sparse-columns-so-they-line-up-with-existing-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
set cell C to:
=vlookup(A1,sheet2!A:B,1,FALSE)
and cell D to:
=vlookup(A1,sheet2!A:B,2,FALSE)
Where your data in sheet 2 is in columns A and B.
answered Jan 8 at 23:06
BrianBrian
3475
add a comment |
set cell C to:
=vlookup(A1,sheet2!A:B,1,FALSE)
and cell D to:
=vlookup(A1,sheet2!A:B,2,FALSE)
Where your data in sheet 2 is in columns A and B.
answered Jan 8 at 23:06
BrianBrian
3475
add a comment |
set cell C to:
=vlookup(A1,sheet2!A:B,1,FALSE)
and cell D to:
=vlookup(A1,sheet2!A:B,2,FALSE)
Where your data in sheet 2 is in columns A and B.
answered Jan 8 at 23:06
BrianBrian
3475
set cell C to:
=vlookup(A1,sheet2!A:B,1,FALSE)
and cell D to:
=vlookup(A1,sheet2!A:B,2,FALSE)
Where your data in sheet 2 is in columns A and B.
answered Jan 8 at 23:06
BrianBrian
3475
answered Jan 8 at 23:06
BrianBrian
3475
answered Jan 8 at 23:06
BrianBrian
3475
answered Jan 8 at 23:06
BrianBrian
3475
3475
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1391716%2fhow-to-paste-sparse-columns-so-they-line-up-with-existing-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
4
Use VLOOKUP()..
– Scott Craner
Jan 8 at 0:17