Datatable manipulation with blank rows using LINQ

Help Studio
, ,
1

Hi Team,

Input is my datatable below,

image
image1066×234 11 KB

My output:

image
image1195×262 15.2 KB

The last column will be of list type or any feasible type which can be used in for each. using LINQ.
As we can see here, for particular order type sales organization, pi number, there can be multiple cartoon numbers. I need that in the same row.

2

@yash.choursia

Can you please explain what is that data? and how you want to append

cheers

3

As we can see here, for particular order type sales organisation, pi number, there can be multiple cartoon numbers. I need that in the same row.

4

its more a fill-up value case easier to handle within a for-each row instead with a LINQ

5

Can you help me with the logic for for each?

6

@Yoichi Please help.

7

with this building block:

grafik
grafik715×319 18.3 KB

we can do within the
then block:

  • adding the Cartoon number to a list - ListGroupCartoons
  • setting “blank” value
    Else Block:
  • memorizing the block start index
  • setting the ListGroupCartoons e.g. by: String.Join(“,”, ListGroupCartoons)