How to duplicate items per number

[JasXel]

Hi all,

I am stuck with a problem that in my mind I think there should be a simple solution, but I can't get to it.

I have a list of 10 people, and I have a list of 5 items (UK, US, China, South Africa, Sweden). I have to combine this list to have each one of he 10 people have 5 lines to have the items. So instead having 2 lists as:

1
2...
9
10

and

UK
US...
Sweden

I need to have


1 UK
1 US
1 China
1 SA
1 Sweden
2 UK
2 US
2 China
2 SA
2 Sweden


how can enhance my peoples list with the countries in a quick way?

Hope my question is understandable.

Thanks a lot for your help

[Glenn Kennedy]

Use:
=IFERROR(INDEX($A$1:$A$10,1+INT((ROWS(E$1:E1)-1)/5)),"")

and
=IF(D1="","",INDEX($B$1:$B$5,1+MOD((ROWS(E$1:E1)-1),5)))

both copied down.

[JasXel]

Thant works. Thanks a lot!

[Glenn Kennedy]

You're welcome and thanks for the feedback.