Column List to Multiple Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TStirling - 08 Jan 2008 16:25 GMT

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.

Reply to this Message

Pete_UK - 08 Jan 2008 17:19 GMT

Do you have a maximum of four 3-digit numbers associated with each
account number, or can it be more than this? (so you would need to use
columns AA, AB etc).

You could do it with a formula method, then fix the values, then use
Autofilter to delete the blank rows.

Hope this helps.

Pete

> 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
[quoted text clipped - 6 lines]
> 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.

Reply to this Message