How can I transpose columns into rows in excel (a little more complex of a case)
Say I have a detail with about 10,000 rows, where each row is broken out into an arrangement, and I have columns for each month of the arrangement where an amount is recognized. So it would be like (...some customer information..., arrangement #1, January, February, ... December). How can I make a separate row for each month in excel? So the rows would now look like (... some customer information..., arrangement #1, January) then (...some customer information, arrangement #1, February). Is there a tool within excel I can use? Is there a formula that would help me? Thanks!
microsoft-excel
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
add a comment |
Say I have a detail with about 10,000 rows, where each row is broken out into an arrangement, and I have columns for each month of the arrangement where an amount is recognized. So it would be like (...some customer information..., arrangement #1, January, February, ... December). How can I make a separate row for each month in excel? So the rows would now look like (... some customer information..., arrangement #1, January) then (...some customer information, arrangement #1, February). Is there a tool within excel I can use? Is there a formula that would help me? Thanks!
microsoft-excel
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
What makes this more complex than any other columns to rows transposing? Can you mock up an example to illustrate? It's hard to understand from this verbal description.
– fixer1234
Jan 20 at 23:56
It seemed hard to transpose with a function because it required the creation of multiple new rows while pulling in the other data for each arrangement into each newly created row. I actually solved the problem much more simply. Just copying and pasting the detail into different tabs for each month and then manually combining all of them
– Tarheel033
Jan 21 at 0:26
Select the entire range, then copy, paste-special transpose will transpose everything. It isn't clear from the question what would be different from that.
– fixer1234
Jan 21 at 0:37
That isn't it I don't think you understood the question. All good though I solved it thanks!
– Tarheel033
Jan 21 at 13:07
The question isn't very clear, which makes it not especially useful to other readers as-is (the purpose of the site is a knowledge base of questions and solutions that can be shared by others). It would help if you could mock up a simple example to make the requirement clearer. Since you solved it, you could also post an answer with your solution to help others with the same problem. But if you are satisfied to just abandon a question that's unclear to others, consider deleting it.
– fixer1234
Jan 21 at 19:17
add a comment |
Say I have a detail with about 10,000 rows, where each row is broken out into an arrangement, and I have columns for each month of the arrangement where an amount is recognized. So it would be like (...some customer information..., arrangement #1, January, February, ... December). How can I make a separate row for each month in excel? So the rows would now look like (... some customer information..., arrangement #1, January) then (...some customer information, arrangement #1, February). Is there a tool within excel I can use? Is there a formula that would help me? Thanks!
microsoft-excel
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
Say I have a detail with about 10,000 rows, where each row is broken out into an arrangement, and I have columns for each month of the arrangement where an amount is recognized. So it would be like (...some customer information..., arrangement #1, January, February, ... December). How can I make a separate row for each month in excel? So the rows would now look like (... some customer information..., arrangement #1, January) then (...some customer information, arrangement #1, February). Is there a tool within excel I can use? Is there a formula that would help me? Thanks!
microsoft-excel
microsoft-excel
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
asked Jan 20 at 23:34
Tarheel033Tarheel033
11
11
What makes this more complex than any other columns to rows transposing? Can you mock up an example to illustrate? It's hard to understand from this verbal description.
– fixer1234
Jan 20 at 23:56
It seemed hard to transpose with a function because it required the creation of multiple new rows while pulling in the other data for each arrangement into each newly created row. I actually solved the problem much more simply. Just copying and pasting the detail into different tabs for each month and then manually combining all of them
– Tarheel033
Jan 21 at 0:26
Select the entire range, then copy, paste-special transpose will transpose everything. It isn't clear from the question what would be different from that.
– fixer1234
Jan 21 at 0:37
That isn't it I don't think you understood the question. All good though I solved it thanks!
– Tarheel033
Jan 21 at 13:07
The question isn't very clear, which makes it not especially useful to other readers as-is (the purpose of the site is a knowledge base of questions and solutions that can be shared by others). It would help if you could mock up a simple example to make the requirement clearer. Since you solved it, you could also post an answer with your solution to help others with the same problem. But if you are satisfied to just abandon a question that's unclear to others, consider deleting it.
– fixer1234
Jan 21 at 19:17
add a comment |
What makes this more complex than any other columns to rows transposing? Can you mock up an example to illustrate? It's hard to understand from this verbal description.
– fixer1234
Jan 20 at 23:56
It seemed hard to transpose with a function because it required the creation of multiple new rows while pulling in the other data for each arrangement into each newly created row. I actually solved the problem much more simply. Just copying and pasting the detail into different tabs for each month and then manually combining all of them
– Tarheel033
Jan 21 at 0:26
Select the entire range, then copy, paste-special transpose will transpose everything. It isn't clear from the question what would be different from that.
– fixer1234
Jan 21 at 0:37
That isn't it I don't think you understood the question. All good though I solved it thanks!
– Tarheel033
Jan 21 at 13:07
The question isn't very clear, which makes it not especially useful to other readers as-is (the purpose of the site is a knowledge base of questions and solutions that can be shared by others). It would help if you could mock up a simple example to make the requirement clearer. Since you solved it, you could also post an answer with your solution to help others with the same problem. But if you are satisfied to just abandon a question that's unclear to others, consider deleting it.
– fixer1234
Jan 21 at 19:17
What makes this more complex than any other columns to rows transposing? Can you mock up an example to illustrate? It's hard to understand from this verbal description.
– fixer1234
Jan 20 at 23:56
What makes this more complex than any other columns to rows transposing? Can you mock up an example to illustrate? It's hard to understand from this verbal description.
– fixer1234
Jan 20 at 23:56
It seemed hard to transpose with a function because it required the creation of multiple new rows while pulling in the other data for each arrangement into each newly created row. I actually solved the problem much more simply. Just copying and pasting the detail into different tabs for each month and then manually combining all of them
– Tarheel033
Jan 21 at 0:26
It seemed hard to transpose with a function because it required the creation of multiple new rows while pulling in the other data for each arrangement into each newly created row. I actually solved the problem much more simply. Just copying and pasting the detail into different tabs for each month and then manually combining all of them
– Tarheel033
Jan 21 at 0:26
Select the entire range, then copy, paste-special transpose will transpose everything. It isn't clear from the question what would be different from that.
– fixer1234
Jan 21 at 0:37
Select the entire range, then copy, paste-special transpose will transpose everything. It isn't clear from the question what would be different from that.
– fixer1234
Jan 21 at 0:37
That isn't it I don't think you understood the question. All good though I solved it thanks!
– Tarheel033
Jan 21 at 13:07
That isn't it I don't think you understood the question. All good though I solved it thanks!
– Tarheel033
Jan 21 at 13:07
The question isn't very clear, which makes it not especially useful to other readers as-is (the purpose of the site is a knowledge base of questions and solutions that can be shared by others). It would help if you could mock up a simple example to make the requirement clearer. Since you solved it, you could also post an answer with your solution to help others with the same problem. But if you are satisfied to just abandon a question that's unclear to others, consider deleting it.
– fixer1234
Jan 21 at 19:17
The question isn't very clear, which makes it not especially useful to other readers as-is (the purpose of the site is a knowledge base of questions and solutions that can be shared by others). It would help if you could mock up a simple example to make the requirement clearer. Since you solved it, you could also post an answer with your solution to help others with the same problem. But if you are satisfied to just abandon a question that's unclear to others, consider deleting it.
– fixer1234
Jan 21 at 19:17
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%2f1396417%2fhow-can-i-transpose-columns-into-rows-in-excel-a-little-more-complex-of-a-case%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%2f1396417%2fhow-can-i-transpose-columns-into-rows-in-excel-a-little-more-complex-of-a-case%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
What makes this more complex than any other columns to rows transposing? Can you mock up an example to illustrate? It's hard to understand from this verbal description.
– fixer1234
Jan 20 at 23:56
It seemed hard to transpose with a function because it required the creation of multiple new rows while pulling in the other data for each arrangement into each newly created row. I actually solved the problem much more simply. Just copying and pasting the detail into different tabs for each month and then manually combining all of them
– Tarheel033
Jan 21 at 0:26
Select the entire range, then copy, paste-special transpose will transpose everything. It isn't clear from the question what would be different from that.
– fixer1234
Jan 21 at 0:37
That isn't it I don't think you understood the question. All good though I solved it thanks!
– Tarheel033
Jan 21 at 13:07
The question isn't very clear, which makes it not especially useful to other readers as-is (the purpose of the site is a knowledge base of questions and solutions that can be shared by others). It would help if you could mock up a simple example to make the requirement clearer. Since you solved it, you could also post an answer with your solution to help others with the same problem. But if you are satisfied to just abandon a question that's unclear to others, consider deleting it.
– fixer1234
Jan 21 at 19:17