how to merge two cell in csv file

Question

how to merge two cell in csv file like as excel

I want to merge two cell in csv file file as

Header         Id        Name                       mobileNo
Sub-Header     id   first Name last Name     countryCode  MobNumber  

Answer 1

This is not possible

• A comma-separated values (CSV) file stores tabular data (numbers and text) in plain text.
• It is just data, with no attached formatting or knowledge of how the cells should be merged when the data is imported.

You could use a script maybe like python to merge them, refer this link https://dzone.com/articles/merging-cells