Excel VBA – Moving repeat values for distinct UUIDs from multiple rows to columns
I have a list of UUIDs with corresponding values in a column. One UUID can have multiple values so it can have repeat rows, or a the UUID can be unique and have multiple values concatenated in the cell. I have attached an example. I am having trouble creating a dynamic macro that can address both issues.
How can I solve my problem?
Data structure example
microsoft-excel vba
add a comment |
I have a list of UUIDs with corresponding values in a column. One UUID can have multiple values so it can have repeat rows, or a the UUID can be unique and have multiple values concatenated in the cell. I have attached an example. I am having trouble creating a dynamic macro that can address both issues.
How can I solve my problem?
Data structure example
microsoft-excel vba
So, you're trying to put those UIDs in the "Values" column? How do you know which UID to put in the Values column?
– BruceWayne
Feb 5 at 18:16
(1) Please clarify what you are trying to do. Your text says that there can be multiple rows for the same UUID, but your image shows a transformation from values in multiple columns of one row to multiple rows. And you both describe and show multiple values in the same cell, separated by commas, but you give no indication what you want done with those. (2) Do you mean something specific by “dynamic macro” (as opposed to some other sort of macro)? (3) Do you specifically require a VBA solution, or will you consider one that uses worksheet formulas?
– Scott
Feb 5 at 19:09
Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 5 at 19:09
add a comment |
I have a list of UUIDs with corresponding values in a column. One UUID can have multiple values so it can have repeat rows, or a the UUID can be unique and have multiple values concatenated in the cell. I have attached an example. I am having trouble creating a dynamic macro that can address both issues.
How can I solve my problem?
Data structure example
microsoft-excel vba
I have a list of UUIDs with corresponding values in a column. One UUID can have multiple values so it can have repeat rows, or a the UUID can be unique and have multiple values concatenated in the cell. I have attached an example. I am having trouble creating a dynamic macro that can address both issues.
How can I solve my problem?
Data structure example
microsoft-excel vba
microsoft-excel vba
edited Feb 5 at 18:53
Scott
15.9k113990
15.9k113990
asked Feb 5 at 17:52
Daniel SwiftDaniel Swift
1
1
So, you're trying to put those UIDs in the "Values" column? How do you know which UID to put in the Values column?
– BruceWayne
Feb 5 at 18:16
(1) Please clarify what you are trying to do. Your text says that there can be multiple rows for the same UUID, but your image shows a transformation from values in multiple columns of one row to multiple rows. And you both describe and show multiple values in the same cell, separated by commas, but you give no indication what you want done with those. (2) Do you mean something specific by “dynamic macro” (as opposed to some other sort of macro)? (3) Do you specifically require a VBA solution, or will you consider one that uses worksheet formulas?
– Scott
Feb 5 at 19:09
Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 5 at 19:09
add a comment |
So, you're trying to put those UIDs in the "Values" column? How do you know which UID to put in the Values column?
– BruceWayne
Feb 5 at 18:16
(1) Please clarify what you are trying to do. Your text says that there can be multiple rows for the same UUID, but your image shows a transformation from values in multiple columns of one row to multiple rows. And you both describe and show multiple values in the same cell, separated by commas, but you give no indication what you want done with those. (2) Do you mean something specific by “dynamic macro” (as opposed to some other sort of macro)? (3) Do you specifically require a VBA solution, or will you consider one that uses worksheet formulas?
– Scott
Feb 5 at 19:09
Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 5 at 19:09
So, you're trying to put those UIDs in the "Values" column? How do you know which UID to put in the Values column?
– BruceWayne
Feb 5 at 18:16
So, you're trying to put those UIDs in the "Values" column? How do you know which UID to put in the Values column?
– BruceWayne
Feb 5 at 18:16
(1) Please clarify what you are trying to do. Your text says that there can be multiple rows for the same UUID, but your image shows a transformation from values in multiple columns of one row to multiple rows. And you both describe and show multiple values in the same cell, separated by commas, but you give no indication what you want done with those. (2) Do you mean something specific by “dynamic macro” (as opposed to some other sort of macro)? (3) Do you specifically require a VBA solution, or will you consider one that uses worksheet formulas?
– Scott
Feb 5 at 19:09
(1) Please clarify what you are trying to do. Your text says that there can be multiple rows for the same UUID, but your image shows a transformation from values in multiple columns of one row to multiple rows. And you both describe and show multiple values in the same cell, separated by commas, but you give no indication what you want done with those. (2) Do you mean something specific by “dynamic macro” (as opposed to some other sort of macro)? (3) Do you specifically require a VBA solution, or will you consider one that uses worksheet formulas?
– Scott
Feb 5 at 19:09
Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 5 at 19:09
Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 5 at 19:09
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%2f1402345%2fexcel-vba-moving-repeat-values-for-distinct-uuids-from-multiple-rows-to-column%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%2f1402345%2fexcel-vba-moving-repeat-values-for-distinct-uuids-from-multiple-rows-to-column%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
So, you're trying to put those UIDs in the "Values" column? How do you know which UID to put in the Values column?
– BruceWayne
Feb 5 at 18:16
(1) Please clarify what you are trying to do. Your text says that there can be multiple rows for the same UUID, but your image shows a transformation from values in multiple columns of one row to multiple rows. And you both describe and show multiple values in the same cell, separated by commas, but you give no indication what you want done with those. (2) Do you mean something specific by “dynamic macro” (as opposed to some other sort of macro)? (3) Do you specifically require a VBA solution, or will you consider one that uses worksheet formulas?
– Scott
Feb 5 at 19:09
Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Feb 5 at 19:09