Get all combinations of the first column's val

Question

I have an irregular table in Excel:

A A1 A2 A3
B B1
C C1 C2 C3 C4
...

How can I get the following its representation?

A A1
A A2
A A3
B B1
C C1
C C2
C C3
C C4
...

Answer 1

This answer in SuperUser to Transform horizontal table layout to vertical table using VBA appears to give exactly what you are looking for.

The code is self explanatory by virtue of working step by step.

Hope it helps.