create 3 sheet which has records look like having many to many relationship

[Amit_Pathare1491]

table 1            

item no

1

2

3

table 2

Name

a

b

c

expected table

item no	Name
1	a
1	b
1	c
2	a
2	b
2	c
3	a
3	b
3	c

PLease let me know how can be this implemented? is there any automated way to do this?

[#2]

@Amit_Pathare1491 

I have added both a formula(D2:D10)&(E1:E10) and a macro(shall run in G:H).

IF(COUNTIF($D$2:D2,D2)<=3,D2,D2+1)

[#3]

@Amit_Pathare1491 

As variant wit Power Query - query both, add one to another as custom column and expand