Vhj

[Anish_Kumar2 (Anish Kumar)]

I have attached Input File

Book1.xlsx (158.6 KB)

and I want output like this which I mention below without use pivot activity.
If there is any linq or vb.net code can anyone help me with it

[AMAN_GUPTA]

Hi @Anish_Kumar2 ,

You can code the functionality using Excel macros. Then invoke those macros in UiPath.

[lrtetala (Lakshman Reddy)]

Hi @Anish_Kumar2

You can check on this

Eferf

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 [image] Hope it helps!!