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.

Table

OutPut required:

Table 2

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

2 Likes

@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.