Replace different rows of same data with different data
my title might be a little misleading, but I can explain further in here. Picture for reference:
According to the sample data given above, I want to ask is there any way to replace the "a" in column 2 with the data given in column 1, so that it will result in column 4?
Thank you in advance for the responses.
microsoft-excel
add a comment |
my title might be a little misleading, but I can explain further in here. Picture for reference:
According to the sample data given above, I want to ask is there any way to replace the "a" in column 2 with the data given in column 1, so that it will result in column 4?
Thank you in advance for the responses.
microsoft-excel
Can column 1 be anything of any length, not just sequential numbers or row numbers, or is it literally "1,2,3,4"? Is the "a" a placeholder for some uniform thing between the open parenthesis and the first comma, but not necessarily a single character, or is it literally "a"?
– fixer1234
Feb 14 at 10:14
1
LikeSUBSTITUTE(B1,"a",A1)
?
– Máté Juhász
Feb 14 at 10:43
@fixer1234 i figured it out, thank you!
– Wan Jun
Feb 15 at 4:00
@MátéJuhász i figured it out too, thank you!
– Wan Jun
Feb 15 at 4:01
1
Kudos for figuring it out. Can you post an answer with your solution? The purpose of questions on the site is to build a knowledge base of solutions for people to share. If the question is unambiguous, people can share solutions even if you're already satisfied. If it's ambiguous (like this one is), and you wish to just abandon it, it would be better to delete the question. Thanks.
– fixer1234
Feb 15 at 4:08
add a comment |
my title might be a little misleading, but I can explain further in here. Picture for reference:
According to the sample data given above, I want to ask is there any way to replace the "a" in column 2 with the data given in column 1, so that it will result in column 4?
Thank you in advance for the responses.
microsoft-excel
my title might be a little misleading, but I can explain further in here. Picture for reference:
According to the sample data given above, I want to ask is there any way to replace the "a" in column 2 with the data given in column 1, so that it will result in column 4?
Thank you in advance for the responses.
microsoft-excel
microsoft-excel
edited Feb 14 at 9:57
fixer1234
18.9k144982
18.9k144982
asked Feb 14 at 2:45
Wan JunWan Jun
1
1
Can column 1 be anything of any length, not just sequential numbers or row numbers, or is it literally "1,2,3,4"? Is the "a" a placeholder for some uniform thing between the open parenthesis and the first comma, but not necessarily a single character, or is it literally "a"?
– fixer1234
Feb 14 at 10:14
1
LikeSUBSTITUTE(B1,"a",A1)
?
– Máté Juhász
Feb 14 at 10:43
@fixer1234 i figured it out, thank you!
– Wan Jun
Feb 15 at 4:00
@MátéJuhász i figured it out too, thank you!
– Wan Jun
Feb 15 at 4:01
1
Kudos for figuring it out. Can you post an answer with your solution? The purpose of questions on the site is to build a knowledge base of solutions for people to share. If the question is unambiguous, people can share solutions even if you're already satisfied. If it's ambiguous (like this one is), and you wish to just abandon it, it would be better to delete the question. Thanks.
– fixer1234
Feb 15 at 4:08
add a comment |
Can column 1 be anything of any length, not just sequential numbers or row numbers, or is it literally "1,2,3,4"? Is the "a" a placeholder for some uniform thing between the open parenthesis and the first comma, but not necessarily a single character, or is it literally "a"?
– fixer1234
Feb 14 at 10:14
1
LikeSUBSTITUTE(B1,"a",A1)
?
– Máté Juhász
Feb 14 at 10:43
@fixer1234 i figured it out, thank you!
– Wan Jun
Feb 15 at 4:00
@MátéJuhász i figured it out too, thank you!
– Wan Jun
Feb 15 at 4:01
1
Kudos for figuring it out. Can you post an answer with your solution? The purpose of questions on the site is to build a knowledge base of solutions for people to share. If the question is unambiguous, people can share solutions even if you're already satisfied. If it's ambiguous (like this one is), and you wish to just abandon it, it would be better to delete the question. Thanks.
– fixer1234
Feb 15 at 4:08
Can column 1 be anything of any length, not just sequential numbers or row numbers, or is it literally "1,2,3,4"? Is the "a" a placeholder for some uniform thing between the open parenthesis and the first comma, but not necessarily a single character, or is it literally "a"?
– fixer1234
Feb 14 at 10:14
Can column 1 be anything of any length, not just sequential numbers or row numbers, or is it literally "1,2,3,4"? Is the "a" a placeholder for some uniform thing between the open parenthesis and the first comma, but not necessarily a single character, or is it literally "a"?
– fixer1234
Feb 14 at 10:14
1
1
Like
SUBSTITUTE(B1,"a",A1)
?– Máté Juhász
Feb 14 at 10:43
Like
SUBSTITUTE(B1,"a",A1)
?– Máté Juhász
Feb 14 at 10:43
@fixer1234 i figured it out, thank you!
– Wan Jun
Feb 15 at 4:00
@fixer1234 i figured it out, thank you!
– Wan Jun
Feb 15 at 4:00
@MátéJuhász i figured it out too, thank you!
– Wan Jun
Feb 15 at 4:01
@MátéJuhász i figured it out too, thank you!
– Wan Jun
Feb 15 at 4:01
1
1
Kudos for figuring it out. Can you post an answer with your solution? The purpose of questions on the site is to build a knowledge base of solutions for people to share. If the question is unambiguous, people can share solutions even if you're already satisfied. If it's ambiguous (like this one is), and you wish to just abandon it, it would be better to delete the question. Thanks.
– fixer1234
Feb 15 at 4:08
Kudos for figuring it out. Can you post an answer with your solution? The purpose of questions on the site is to build a knowledge base of solutions for people to share. If the question is unambiguous, people can share solutions even if you're already satisfied. If it's ambiguous (like this one is), and you wish to just abandon it, it would be better to delete the question. Thanks.
– fixer1234
Feb 15 at 4:08
add a comment |
0
active
oldest
votes
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%2f1405513%2freplace-different-rows-of-same-data-with-different-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1405513%2freplace-different-rows-of-same-data-with-different-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
Can column 1 be anything of any length, not just sequential numbers or row numbers, or is it literally "1,2,3,4"? Is the "a" a placeholder for some uniform thing between the open parenthesis and the first comma, but not necessarily a single character, or is it literally "a"?
– fixer1234
Feb 14 at 10:14
1
Like
SUBSTITUTE(B1,"a",A1)
?– Máté Juhász
Feb 14 at 10:43
@fixer1234 i figured it out, thank you!
– Wan Jun
Feb 15 at 4:00
@MátéJuhász i figured it out too, thank you!
– Wan Jun
Feb 15 at 4:01
1
Kudos for figuring it out. Can you post an answer with your solution? The purpose of questions on the site is to build a knowledge base of solutions for people to share. If the question is unambiguous, people can share solutions even if you're already satisfied. If it's ambiguous (like this one is), and you wish to just abandon it, it would be better to delete the question. Thanks.
– fixer1234
Feb 15 at 4:08