need help about vb formula on macros

hi guys I need ur help

suppose I have data :

a1 b1
a b 1 2 3

I need vb formula on macros that will create something like this

a1 b1 c1
a b 1 2 3 1
a b 1 2 3 2
a b 1 2 3 3
a b 1 2 3 1
a b 1 2 3 2
a b 1 2 3 3

here I gave u my work

COLOR AVAILABLE SIZE AVAILABLE
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0


then the result should be

COLOR AVAILABLE SIZE AVAILABLE SIZE AVAILABLE
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 3.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 4.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 1.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 2.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 3.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 4.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 1.0
WHITE/ATHLETIC RED (SDU), WHITE/PINK (WPN) 3.0, 4.0, 1.0, 2.0 2.0


thankx alot