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;
}







0















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




  1. Goal 1


  2. Goal 2


  3. Goal 3











share|improve this question







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


















0















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




  1. Goal 1


  2. Goal 2


  3. Goal 3











share|improve this question







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














0












0








0








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




  1. Goal 1


  2. Goal 2


  3. Goal 3











share|improve this question







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




  1. Goal 1


  2. Goal 2


  3. Goal 3








microsoft-excel






share|improve this question







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.











share|improve this question







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.









share|improve this question




share|improve this question






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




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



















  • 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










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.










draft saved

draft discarded


















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.










draft saved

draft discarded


















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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...

Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...