I have a situation where I need your help with LINQ only.
I need do a vlookup from Data Table 1 to Data Table 2 and fetch the Week Format and write into a TempDT.
The second part is to convert the TempDT from Column to Row Data into Final DT.
I am also attaching the excel file.
Thank you in advance for support.
ManjeshPivot.xlsx (30.3 KB)