Add two data rows as one data row from one data table

activities
studio

#1

I have twenty data rows but it has split as forty lines, so I would like to add two data lines as one line


#2

Could you please elaborate a little more?
Maybe with an example?


#3

Yeah sure… I need to read a excel which suppose the have twenty line and 8 columns… but the input file is like mentioned below

Name Age City State
Country Marital status Occupation Phone num
Raj 23 Chennai TN
India Single Study 9876543211
Geetha 34 Hydrabad TL
India Married Working 9876543289
Sameep 32 Chennai TN
India Married Business 9865769766
Suraj 26 Chennai TN
India Single Study 9876543289
Hari 28 Bangalore KA
India Single IT 9876543212
Punitha 29 Coimbatore TN
India Single Business 9865769766
Kavi 32 Chennai TN
India Single Study 9876543214
Raj 23 Chennai TN
Pabi Single Business 9876543215
Selva 35 Chennai TN
India Single IT 9876543211
Humrith 28 Chennai TN
India Single Agri 9876543210
Sharik 45 Chennai TN
India Married Hotel Management 9876543215
Reshi 36 Chennai TN
India Single IT 9876543219
Maapi 36 Chennai TN
India Single Study 9876543211
Nisha 24 Chennai TN
India Married Business 9876543217
Mega 26 Chennai TN
India Single Study 9876543212
Manu 25 Chennai TN
India Married Business 9876543218
Prabha 29 Chennai TN
India Single Study 9876543215
Pavithra 23 Chennai TN
India Married Study 9876543212
Bala 23 Chennai TN
India Married Study 9876543216

So I would like to make this an order and read the file… could you please help me with that