Hi
Im after some help with a macro as im not the best when it comes to VBA.
I have values in one column and corresponding values in the next column. I wnat to move the corresponding values to a new row and have them in the row instead of the column.
hear is an example,
Im after some help with a macro as im not the best when it comes to VBA.
I have values in one column and corresponding values in the next column. I wnat to move the corresponding values to a new row and have them in the row instead of the column.
hear is an example,
Workpackage 020305.csv | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | |||
1 | MHB4200 | AAH-A-0-12200 | |||||||||
2 | SWD6900 | AAH-A-0-12201 | MHB6000 | MHB7000 | MHB4300 | MHB4200 | MHB3100 | MHB2200 | |||
3 | MHB6000 | AAH-A-0-12201 | |||||||||
4 | MHB7000 | AAH-A-0-12201 | |||||||||
5 | MHB4300 | AAH-A-0-12201 | |||||||||
6 | MHB4200 | AAH-A-0-12201 | |||||||||
7 | MHB3100 | AAH-A-0-12201 | |||||||||
8 | MHB2200 | AAH-A-0-12201 | |||||||||
9 | MHB6000 | AAH-A-0-12201scan | MHB6000 | MHB7000 | SWD6500 | SWD6900 | |||||
10 | MHB7000 | AAH-A-0-12201scan | |||||||||
11 | SWD6500 | AAH-A-0-12201scan | |||||||||
12 | SWD6900 | AAH-A-0-12201scan | |||||||||
13 | MHB6000 | AAH-A-0-SK0015 | |||||||||
14 | MHB4200 | AAH-A-0-SK0015 | |||||||||
15 | MHB7000 | AAH-A-0-SK0015 | |||||||||
16 | MHB6000 | AAH-A-0-SK0016 | |||||||||
17 | MHB4200 | AAH-A-0-SK0016 | |||||||||
18 | MHB7000 | AAH-A-0-SK0016 | |||||||||
19 | MHB6000 | AAH-A-0-SK0017 | |||||||||
20 | MHB4200 | AAH-A-0-SK0017 | |||||||||
21 | MHB7000 | AAH-A-0-SK0017 | |||||||||
22 | MHB6000 | AAH-A-0-SK0018 | |||||||||
Workpackage 020305 |