Excel - Move information from one column to specific multiple columns on another tab Unicorn...
Putting Ant-Man on house arrest
Married in secret, can marital status in passport be changed at a later date?
My admission is revoked after accepting the admission offer
Are all CP/M-80 implementations binary compatible?
Mistake in years of experience in resume?
Passing args from the bash script to the function in the script
What ability score does a Hexblade's Pact Weapon use for attack and damage when wielded by another character?
Does Feeblemind produce an ongoing magical effect that can be dispelled?
How can I wire a 9-position switch so that each position turns on one more LED than the one before?
Implementing 3DES algorithm in Java: is my code secure?
Can you stand up from being prone using Skirmisher outside of your turn?
Has a Nobel Peace laureate ever been accused of war crimes?
Is Bran literally the world's memory?
Second order approximation of the loss function (Deep learning book, 7.33)
"Whatever a Russian does, they end up making the Kalashnikov gun"? Are there any similar proverbs in English?
std::is_constructible on incomplete types
How to get even lighting when using flash for group photos near wall?
Is it OK if I do not take the receipt in Germany?
Expansion//Explosion and Siren Stormtamer
Could moose/elk survive in the Amazon forest?
Seek and ye shall find
PIC mathematical operations weird problem
Is it acceptable to use working hours to read general interest books?
What is the best way to deal with NPC-NPC combat?
Excel - Move information from one column to specific multiple columns on another tab
Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraMacro to Move Columns Based on Header Criteria MS Excelhow can I split data into multiple columns seperating only after the first colon in excelSplit column into multiple columns--datewiseMoving Data from One Column into Six ColumnsExcel - how to sum values in one columns based on set of matching rows in another columnExcel - Split long column into multiple columns by empty cell1 long column split to multiple columnsCreating multiple rows from one row of Excel DataExcel - Split one columns values into 2 columns, split on every 2nd rowConvert one column into a new column every 10 rows in Excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
How do I do the following. I have a list of employee data for goals they have set throughout the year. I am trying to get data from one column split into other columns.
For example, each user will have multiple goals and these goals are listed in one column and have different names. I would like to move these goals from column B into C, D, E (on another worksheet tab) so all goals are clearly marked in one row. Please see my table below.
Does anyone know how I do this. I am using it will involve a query based on user ID but I don’t know how to do
Any help would greatly appreciated
A. B. C. D. E.
UserID. Goal Name. Goal 1. Goal 2. Goal 3
Goal 1
Goal 2
Goal 3
microsoft-excel
asked 15 hours ago
TimTim
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
How do I do the following. I have a list of employee data for goals they have set throughout the year. I am trying to get data from one column split into other columns.
For example, each user will have multiple goals and these goals are listed in one column and have different names. I would like to move these goals from column B into C, D, E (on another worksheet tab) so all goals are clearly marked in one row. Please see my table below.
Does anyone know how I do this. I am using it will involve a query based on user ID but I don’t know how to do
Any help would greatly appreciated
A. B. C. D. E.
UserID. Goal Name. Goal 1. Goal 2. Goal 3
Goal 1
Goal 2
Goal 3
microsoft-excel
asked 15 hours ago
TimTim
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hi Tim, and welcome to Super User. What delimits each of the users multiple goals? A carriage return?
– spikey_richie
15 hours ago
Hi there, a new goal would be on a different row of the Excel sheet of column B. So Goal 1 would be Row A, Goal 2 would be on row b
– Tim
15 hours ago
OK, I get you now.
– spikey_richie
15 hours ago
add a comment |
How do I do the following. I have a list of employee data for goals they have set throughout the year. I am trying to get data from one column split into other columns.
For example, each user will have multiple goals and these goals are listed in one column and have different names. I would like to move these goals from column B into C, D, E (on another worksheet tab) so all goals are clearly marked in one row. Please see my table below.
Does anyone know how I do this. I am using it will involve a query based on user ID but I don’t know how to do
Any help would greatly appreciated
A. B. C. D. E.
UserID. Goal Name. Goal 1. Goal 2. Goal 3
Goal 1
Goal 2
Goal 3
microsoft-excel
asked 15 hours ago
TimTim
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
How do I do the following. I have a list of employee data for goals they have set throughout the year. I am trying to get data from one column split into other columns.
For example, each user will have multiple goals and these goals are listed in one column and have different names. I would like to move these goals from column B into C, D, E (on another worksheet tab) so all goals are clearly marked in one row. Please see my table below.
Does anyone know how I do this. I am using it will involve a query based on user ID but I don’t know how to do
Any help would greatly appreciated
A. B. C. D. E.
UserID. Goal Name. Goal 1. Goal 2. Goal 3
Goal 1
Goal 2
Goal 3
microsoft-excel
microsoft-excel
asked 15 hours ago
TimTim
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 15 hours ago
TimTim
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 15 hours ago
TimTim
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 15 hours ago
TimTim
1
asked 15 hours ago
TimTim
1
1
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Tim is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Hi Tim, and welcome to Super User. What delimits each of the users multiple goals? A carriage return?
– spikey_richie
15 hours ago
Hi there, a new goal would be on a different row of the Excel sheet of column B. So Goal 1 would be Row A, Goal 2 would be on row b
– Tim
15 hours ago
OK, I get you now.
– spikey_richie
15 hours ago
add a comment |
Hi Tim, and welcome to Super User. What delimits each of the users multiple goals? A carriage return?
– spikey_richie
15 hours ago
Hi there, a new goal would be on a different row of the Excel sheet of column B. So Goal 1 would be Row A, Goal 2 would be on row b
– Tim
15 hours ago
OK, I get you now.
– spikey_richie
15 hours ago
Hi Tim, and welcome to Super User. What delimits each of the users multiple goals? A carriage return?
– spikey_richie
15 hours ago
Hi Tim, and welcome to Super User. What delimits each of the users multiple goals? A carriage return?
– spikey_richie
15 hours ago
Hi there, a new goal would be on a different row of the Excel sheet of column B. So Goal 1 would be Row A, Goal 2 would be on row b
– Tim
15 hours ago
Hi there, a new goal would be on a different row of the Excel sheet of column B. So Goal 1 would be Row A, Goal 2 would be on row b
– Tim
15 hours ago
OK, I get you now.
– spikey_richie
15 hours ago
OK, I get you now.
– spikey_richie
15 hours ago
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
});
}
});
Tim is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1429076%2fexcel-move-information-from-one-column-to-specific-multiple-columns-on-another%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
Tim is a new contributor. Be nice, and check out our Code of Conduct.
Tim is a new contributor. Be nice, and check out our Code of Conduct.
Tim is a new contributor. Be nice, and check out our Code of Conduct.
Tim is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1429076%2fexcel-move-information-from-one-column-to-specific-multiple-columns-on-another%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
Hi Tim, and welcome to Super User. What delimits each of the users multiple goals? A carriage return?
– spikey_richie
15 hours ago
Hi there, a new goal would be on a different row of the Excel sheet of column B. So Goal 1 would be Row A, Goal 2 would be on row b
– Tim
15 hours ago
OK, I get you now.
– spikey_richie
15 hours ago