Splitting rows in csv with comma separated values

I have csv file, which information (id and text) in column’s looks like in example below: 1, Šildomos grindys 2, Šildomos grindys, Rekuperacinė sistema 3, 4, Skalbimo mašina, Su baldais, Šaldytuvas, Šildomos grindys My desired output is to transfer ID to one row and relate it to its text (it’s for database). Because of csv… Read More Splitting rows in csv with comma separated values