In Excel first Column had Same number then copy first row of second column and paste

Help Activities
, ,
1

image

In this Image remove that red rows and copy from 2 until 2 paste it. If it is Serial number 2 then copy the value (“01-04-2023”)- SUNGAI NIBONG 1911/2023 " and paste until 3serial number
loop all like this

2

Hi,

Can you try the following sample?

image
image1215×1255 38.2 KB

Sample20230613-2L.zip (8.9 KB)

Regards,

1 Like
3

Hi @Narayana_Acharyulu,

You could also try below solution
Read the excel as inputDT datatable

Assign activity:
outputDT=inputDT.clone

Assign activity:
outputDT=(
From row1 In inputDT
From row2 In (
From a In inputDT
Group a By b=a(“S.No”) Into grp=Group
Select grp.first()
).copytodatatable
Where row1(0).tostring=row2(0).tostring
Let col1=row1(0).tostring
Let col2=row2(1).tostring
Select outputDT.rows.add(col1,col2)
).copytodatatable

Hope this helps :slight_smile:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.