How to get matched rows data and also different data please help me its very urgent to me

Help Activities
, ,
1

I have a case where the rows in excel are below pattern

pr ir scode makepoto
123 10 12356 supplier
123 20 12356 supplier
123 30 12356 TS
123 40 12356 TS
12345 10 23456 supplier

new sheet(pattern to send to new queue)
pr ir scode makepoto
123 10,20 12356 supplier

123 30 ,40 12356 TS

12345 10 23456 supplier

if same supplier or Ts for the same pr then combine irs
@THIRU_NANI
@Gangadhar_Athili
@Nithinkrishna

2
3

Actually I am not experienced with linq querys, is it possible to combine based on these no of columns, in the above case they split based on one column(Region)

I need to combine pr, supplier code and makepoto
Please tell me detailed steps
@ppr

4

Howto Shows to begin also a non-linq approach

5

sorry I was not understood

6

DT.Asenumerable.Groupby(Function(r) Tuple.Create(r(“pr”).Tostring,r(“scode”).Tostring,r(“makepoto”).Tostring).Select(Function(g) Clone_DT.Rows.Add({g.First.item(“pr”),String.Join(“,”,g.Select(Function(a) a(“score”).Tostring).Toarray),g.First.item(“makepoto”).Tostring})).Copytodatatable

7

Error ERROR Validation Error Syntax error, ‘,’ expected
Unexpected character ‘“’
Unexpected character ‘”’
) expected
; expected
} expected
Argument missing
Invalid expression term ‘’
‘DataTable’ does not contain a definition for ‘Asenumerable’ and no accessible extension method ‘Asenumerable’ accepting a first argument of type ‘DataTable’ could be found (are you missing a using directive or an assembly reference?)
Non-invocable member ‘Function’ cannot be used like a method.
The name ‘r’ does not exist in the current context
The name ‘Purchase’ does not exist in the current context
The name ‘Requisition’ does not exist in the current context
The name ‘sode’ does not exist in the current context
The name ‘makepoto’ does not exist in the current context
The name ‘g’ does not exist in the current context
The name ‘Clone_dt’ does not exist in the current context
The name ‘a’ does not exist in the current context
The name ‘Copytodatatable’ does not exist in the current context
Only assignment, call, increment, decrement, await, and new object expressions can be used as a statement Sequence.xaml

@Gangadhar_Athili
tried with above but errors coming

8

po.xlsx (18.2 KB)
Sheet1 input
sheet2 output

9

Okay. One more query will the data always be in pairs ?

10

no not always, sometimes it may same, some times it may vary
I given only for 2 different PRS here how the data is coming from sap

11

I am not getting your point, the similar pattern only the data always, sometimes the supplier code is same then we can combine that IRs based on supplier or ts
remaining data which not have the same supplier code that data also needed
po.xlsx (18.2 KB)

reference excel given please check