Reading unstructured data in csv file

[hss]

Hi,

I have a csv file which has data like this. How do i read this and put it into an excel file.?

Pls help!

[kalyanDev]

Try like this once read the csv file and then you will get data table in that data table remove the empty rows and columns then write into excel.

[hss]

hey @kalyanDev thanks… that works, thanks… just wondering how to proceed if a csv file has a combo of structured and unstructed data…

[kalyanDev]

how want the data has to formatted?

[hss]

@kalyanDev I actually want to convert this type of csv file into excel file… but since we cannot create datatable for the unstructed part of the data present in csv file… am trying to figure out how that will work?