How read text file?

I have html 1 file (left side)
but I want to separate data in table to right side.

Please suggest me about it?

can you provide the html file…!@fairymemay


Please provide the correct input file…!


I read file excle and convert to html.
If excle have country more than 1, I want to separate country and create follow countrys.

I want textfile as below.


Please suggest me about it.

Hi @fairymemay,

if u can give me the excel file, it will be easy to separate the table