Hi All,

I am new to vba macros. Can anybody help me with the simple vba code to perform following operation.

I have data in two columns with multiple rows as follows:

Column A Column B
A A1 | A2 | A3
B B1 | B2
C C1 | C2 | C3 | C4
D D1 | D2 | D3 | D4 | D5
...
......
........

I need the final output in the following format:

Column C Column D
A A1
A A2
A A3
B B1
B B2
C C1
C C2
C C3
C C4
D D1
D D2
D D3.......................
...
......
........

Any help would be appreciated