Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 2 July 31st 06 09:45 PM
move list of numbers from one column to multiple columns coach eo Excel Discussion (Misc queries) 12 February 16th 06 08:12 PM
Compare multiple column of data and list out common and unique component in adj columns kuansheng Excel Worksheet Functions 15 February 1st 06 10:49 PM
Change a Column list into multiple rows & columns angelface Excel Worksheet Functions 3 January 28th 06 01:23 AM
How do I create multiple columns from a one-column list in Excel? Melissa Excel Worksheet Functions 5 October 5th 05 03:32 AM


All times are GMT +1. The time now is 05:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"