Eferf

[Anish_Kumar2 (Anish Kumar)]

I have this data

and I want to display like this with help of linq aur vb.net code

[lrtetala (Lakshman Reddy)]

Hi @Anish_Kumar2

Please try this using Pivot Table

I/P:

O/P:

Please find the below xaml for your reference

BlankProcess15.zip (73.3 KB)

Hope this helps!!

[Anish_Kumar2 (Anish Kumar)]

Thanks Irtetala for quick response but without using pivot table or excel activities can be possible.

[Parvathy (PS Parvathy)]

Hi @Anish_Kumar2

Can you send the sample excel so that we can help you out with code.

Regards

[Anish_Kumar2 (Anish Kumar)]

Book1.xlsx (158.6 KB)
PFA Parvathy

[Parvathy (PS Parvathy)]

Hi @Anish_Kumar2

I should consider the column C and D in the given Excel right. Please do send the correct excel as the picture you have posted and excel doesn’t match.

Regards

[Parvathy (PS Parvathy)]

Hi @Anish_Kumar2

I/P :

O/P :

Refer the workflow for better understanding in Sequence.xaml. Please Ignore Main.xaml. Please provide the correct excel so that I can modify the code.

BlankProcess15.zip (72.0 KB)

Hope it helps!!

[Anish_Kumar2 (Anish Kumar)]

@Parvathy

Please Ignore Main.xaml

please refer this excel and input is in sheet1 and output is in output sheet can you make linq for that is possible?

Book1.xlsx (158.6 KB)

[Parvathy (PS Parvathy)]

Hi @Anish_Kumar2

Check out the below workflow for reference. I have used Invoke code as linq will be difficult to form.
BlankProcess15.zip (236.4 KB)
**O/P :**Sheet2 is the output

Hope it helps!!

[Anish_Kumar2 (Anish Kumar)]

Thank you so much :heart _eyes: