I have 3 files,

File-1.csv
-----------
Code
1
2
3
4
5
6
7
8
9
10
[download]

File-2.csv
-----------
Gender,Status
Male,Single
Male,Married
Female,Single
Female,Married
[download]

File-3.csv
Name
Test
Test1
Test2
Test3
Test4
[download]

Need to output file in this format,

Name,Code_or_Gender_or_Status
Test,1
Test,2
Test,3
Test,4
Test,Male
Test,Single
Test1,1
Test1,2
Test1,3
Test1,4
Test1,Male
Test1,Married
Test2,1
Test2,2
Test2,3
Test2,4
Test2,Female
Test2,Single
Test3,1
Test3,2
Test3,3
Test3,4
Test3,Female
Test3,Married
Test4,5
Test4,6
Test4,7
Test4,8
Test4,Male
Test4,Single
Test5,5
Test5,6
Test5,7
Test5,8
Test5,Male
Test5,Married
[download]