Datatable manipulation for the below table

I have a below table. I need to create column D based on the Type. Whe the type is “Fruit”, it should put col A value into D. For others, it should put col C value into D. Please let me know how to achieve it without using For each row.

My requirement is to use Linq query.


OutPut required:

Table 2

Have a look here:
Sugumar8785.xaml (7.4 KB)


@ppr It worked. Thanks :slight_smile:

1 Like

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