I have twenty data rows but it has split as forty lines, so I would like to add two data lines as one line
Could you please elaborate a little more?
Maybe with an example?
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