I have a csv file with 8 columns, one column contains multiple values delimited by ";"
I'd like to split those entries into one row each.
INPUT:
Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8
"test1","test2a;test2b;test2c","test3","test4","test5","test6","test7","test8"
OUTPUT:
Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8
"test1","test2a","test3","test4","test5","test6","test7","test8"
"test1","test2b","test3","test4","test5","test6","test7","test8"
"test1","test2c","test3","test4","test5","test6","test7","test8"
Hi. So splitting column 2 to new rows right? I have written many automation PowerShell scripts. Ready to write your project. Will complete within 1 day