Hi,
Following is the csv file that I am getting. Now I want to merge multiple rows on the basis if col6, col7 and col8 are empty then merge the rows with the above one.
Input csv:
Output that I expect is:
Thanks in advance!
Hi,
Following is the csv file that I am getting. Now I want to merge multiple rows on the basis if col6, col7 and col8 are empty then merge the rows with the above one.
Input csv:
Output that I expect is:
Thanks in advance!
Please follow the steps
String.IsNullOrEmpty(dt.rows(counter1)(5).ToString) andAlso String.IsNullOrEmpty(dt.rows(counter1)(6).ToString) andAlso String.IsNullOrEmpty(dt.rows(counter1)(7).ToString)
dt.rows(counter2)(0) = dt. rows(counter2)(0).Tostring + " "+ rows(counter1)(0).ToString
. Do this for each column by changing 0 to 1 then 2 and so on in multiassign.counter2= counter2+1
and also counter1=counter1+1
At the end of for loop use write range to write the data back to excel
Cheers
Hi @Umer_Shahid ,
Please refer below xaml file to achive your logic
New Microsoft Excel Worksheet.xlsx (10.3 KB)
Sequence.xaml (23.3 KB)
Regards,
Arivu
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.