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. |
All times are GMT +1. The time now is 06:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com