I have this data [image] and I want to display like this with help of linq aur vb.net code [image]

Hi @Anish_Kumar2 Please try this using Pivot Table [image] I/P: [image] O/P: [image] Please find the below xaml for your reference BlankProcess15.zip (73.3 KB) Hope this helps!!

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

Hi @Anish_Kumar2 Can you send the sample excel so that we can help you out with code. Regards

Book1.xlsx (158.6 KB) PFA 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

Hi @Anish_Kumar2 I/P : [image] O/P : [image] 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!!

[image] 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)

Thank you so much :heart _eyes:

Eferf

Ask in Your Language 中文

Parvathy (PS Parvathy) November 1, 2023, 2:39am 9

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!!

Vhj

Topic		Replies	Views
Vhj Naan Mudhalvan Program	2	944	November 1, 2023
Using linq query to create pivot table for multiple columns Activities excel , activities , question	7	276	July 15, 2024
How to do a Pivot Table using a Linq Query in UiPath? Studio datatable , excel , studio	11	2284	August 10, 2022
Adding rows values into new column using linq Activities excel , activities , question	4	219	July 15, 2024
PIVOT Values_LINQ Activities excel , activities , question	1	51	April 19, 2025

Eferf

Related topics