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 |