Pivot and write excel

I want pivot data and write data to templete excel.
input3.xlsx (14.1 KB)

Output I want to write in sheet(sheetName as Filename_Type)
by sum value (Column Cas,Ins,Che,Car) follow data as below. output3.xlsx (18.3 KB)

Guide me about it please.

It can be done by using VBA macro

Are you familiar with VBA ?

@sulungcayadi DON’T​ know​ about​ VBA.
Guide​ me​ please.

PlotDataExcelPivot.zip (76.6 KB)

I created this,

Input files:

  1. input3.xlsx (your raw data should come with “input” sheet
  2. output template.xlsx (your output template).

Result file as in Robot variable: resultfilename.

Hope it helps.

1 Like

@fairymemay - You can use StudioX feature with in studio, which has the pivot table feature. Have you tried it?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.