Workflow on multiple files and output one file join

Christopher2211

I have Data of different Product Line:

The Original Structure of this Data is:

I did a workflow to modify it:

The Final Structure Data is:

I need to modify each file with the same workflow and then join the data of the 3 files into one.

Thank in advance.

Excel Data linea 1.xlsx

Excel Data linea 2.xlsx

Excel Data linea 3.xlsx

HOW TRANSPOSE TABLE WITH TWO LEVELS OF CATEGORY.yxmd

jasperlch

Since you already have created a workflow to work on one file, the best way to apply the same workflow on multiple file is to convert your current workflow to a batch macro and then create another workflow to run this macro. I will loop through the list of inputting file path.

Before running the workflow, please update input the directory of the folder containing your excel files. 

HOW TRANSPOSE TABLE WITH TWO LEVELS OF CATEGORY.yxzp