Hi My data in excel is shown

Under A
A
B
C

under B
1
2
3
till 100

My expected output should be

Row A Row B
A 1
A 2
A 3
...
C 100

This should be done automatically...in a new excel sheet