Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column List to Multiple Columns
I am using Microsoft Excel 2007. I have an account number in C:2.
Associated with this account number is a set (in a column) of 3 digit numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers in Column W, there are blank spaces under C:2. When the next account number appears (C:6), it has it's own set of 3 digit numbers. I need to take each 3 digit number associated with the account number and move them into adjacent columns on the same line as the account number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would move to Z:2 and so on. I assume I need a VB solution. Can anyone help me with this? Thank you very much in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column List to Multiple Columns
I think I've already replied to this somewhere else - please don't
multi-post. Pete "TStirling" wrote in message ... I am using Microsoft Excel 2007. I have an account number in C:2. Associated with this account number is a set (in a column) of 3 digit numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers in Column W, there are blank spaces under C:2. When the next account number appears (C:6), it has it's own set of 3 digit numbers. I need to take each 3 digit number associated with the account number and move them into adjacent columns on the same line as the account number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would move to Z:2 and so on. I assume I need a VB solution. Can anyone help me with this? Thank you very much in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column List to Multiple Columns
On Jan 8, 11:43*am, "Pete_UK" wrote:
I think I've already replied to this somewhere else - please don't multi-post. Pete "TStirling" wrote in message ... I am using Microsoft Excel 2007. I have an account number in C:2. Associated with this account number is a set (in a column) of 3 digit numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers in Column W, there are blank spaces under C:2. When the next account number appears (C:6), it has it's own set of 3 digit numbers. I need to take each 3 digit number associated with the account number and move them into adjacent columns on the same line as the account number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would move to Z:2 and so on. I assume I need a VB solution. Can anyone help me with this? Thank you very much in advance.- Hide quoted text - - Show quoted text - Sorry, I thought I had to multi-post. Do you know where you replied to this topic? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column List to Multiple Columns
You should have kept track of the newsgroups you posted to - if you
multi-post then your answers get fragmented, and most respondents look at many newsgroups so there is no need to do it. Pete On Jan 8, 6:43*pm, TStirling wrote: On Jan 8, 11:43*am, "Pete_UK" wrote: I think I've already replied to this somewhere else - please don't multi-post. Pete "TStirling" wrote in message ... I am using Microsoft Excel 2007. I have an account number in C:2. Associated with this account number is a set (in a column) of 3 digit numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers in Column W, there are blank spaces under C:2. When the next account number appears (C:6), it has it's own set of 3 digit numbers. I need to take each 3 digit number associated with the account number and move them into adjacent columns on the same line as the account number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would move to Z:2 and so on. I assume I need a VB solution. Can anyone help me with this? Thank you very much in advance.- Hide quoted text - - Show quoted text - Sorry, I thought I had to multi-post. Do you know where you replied to this topic?- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column List to Multiple Columns
I am using Microsoft Excel 2007. I have an account number in C:2.
Associated with this account number is a set (in a column) of 3 digit numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers in Column W, there are blank spaces under C:2. When the next account number appears (C:6), it has it's own set of 3 digit numbers. I need to take each 3 digit number associated with the account number and move them into adjacent columns on the same line as the account number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would move to Z:2 and so on. I assume I need a VB solution. Can anyone help me with this? Thank you very much in advance.- Hide quoted text - I think I've already replied to this somewhere else - please don't multi-post. Sorry, I thought I had to multi-post. Do you know where you replied to this topic? And hence the problem with multi-posting. For your future consideration... From a post by Jeff Johnson in the compiled VB newsgroups: "You have posted this question individually to multiple groups. This is called Multiposting and it's BAD. Replies made in one group will not be visible in the other groups, which may cause multiple people to respond to your question with the same answer because they didn't know someone else had already done it. This is a waste of time. If you MUST post your message to multiple groups, post a single message and select all the groups (or type their names manually in the Newsgroups field, separated by commas) in which you want it to be seen. This is called Crossposting and when used properly it is GOOD." Some additional comment previously posted by me: "You may not see this as a problem, but those of us who volunteer answering questions on newsgroups do see it as a problem. You can't imagine how annoying it is for a volunteer to read a question, research background material, test sample code and then formulate and post an answer to the original question only to go to another newsgroup and find the question posted and ALREADY answered over there. On top of that, if you cross-post your question, all of the readers in all the newsgroups it is cross-posted to see both the original question and all of the answers given to it. This is beneficial to you because then we can add additional material to, add clarification to, as well as add additional examples to an answer you have received previously... that means you end up with a more complete solution to your problem. This is a win-win situation for all of us." Rick |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Column List to Multiple Columns
Well, the OP emailed me directly, so I sent him a sample workbook
showing in stages how to achieve his aim. Pete On Jan 8, 7:28*pm, "Rick Rothstein \(MVP - VB\)" wrote: I am using Microsoft Excel 2007. I have an account number in C:2. Associated with this account number is a set (in a column) of 3 digit numbers in W:2, W:3, W:4, W:5. When there are multiple 3 digit numbers in Column W, there are blank spaces under C:2. When the next account number appears (C:6), it has it's own set of 3 digit numbers. I need to take each 3 digit number associated with the account number and move them into adjacent columns on the same line as the account number. So, W:3 would move to X:2, W:4 would move to Y:2, W:5 would move to Z:2 and so on. I assume I need a VB solution. Can anyone help me with this? Thank you very much in advance.- Hide quoted text - I think I've already replied to this somewhere else - please don't multi-post. Sorry, I thought I had to multi-post. Do you know where you replied to this topic? And hence the problem with multi-posting. For your future consideration... From a post by Jeff Johnson in the compiled VB newsgroups: "You have posted this question individually to multiple groups. *This is called Multiposting and it's BAD. Replies made in one *group will not be visible in the other groups, which may cause *multiple people to respond to your question with the same answer *because they didn't know someone else had already done it. This *is a waste of time. *If you MUST post your message to multiple groups, post a single *message and select all the groups (or type their names manually *in the Newsgroups field, separated by commas) in which you want *it to be seen. This is called Crossposting and when used properly *it is GOOD." Some additional comment previously posted by me: "You may not see this as a problem, but those of us who volunteer *answering questions on newsgroups do see it as a problem. You can't *imagine how annoying it is for a volunteer to read a question, *research background material, test sample code and then formulate *and post an answer to the original question only to go to another *newsgroup and find the question posted and ALREADY answered over *there. On top of that, if you cross-post your question, all of the *readers in all the newsgroups it is cross-posted to see both the *original question and all of the answers given to it. This is *beneficial to you because then we can add additional material to, *add clarification to, as well as add additional examples to an *answer you have received previously... that means you end up with *a more complete solution to your problem. This is a win-win *situation for all of us." Rick- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column List to Multiple Columns | Excel Discussion (Misc queries) | |||
move list of numbers from one column to multiple columns | Excel Discussion (Misc queries) | |||
Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions |