I am trying to extract data from a .xlxs file and to load to a .csv file.
but the issue is under one column in the excel sheet, there are multiple lines in a single row separated by space, for which i am not getting proper data in the CSV file.
please help me how to merge all the lines of single row into a single line.
thanks in advance.
Solved! Go to Solution.
sample excel sheet,
Name Age gender address
Nabarun 25 male Ecity
Milan 23 male Panpana
I want the above format excel sheet like below in csv file.
Nabarun 25 male Ecity,Marathalli,Bangalore
Milan 23 male Panpana,Balaosre, Odisha
there are data in several lines under a single row in the Address column in the excel sheet, these needs to be in a single line as i show above separating each line with a comma.