Consolidate Excel files in one

lgl_

I have +200 Excel files with exactly the same disposition with only two columns (fist column with the name of the field and second column with the value of the field).  I require to build a workflow by which from these +200 Excel files create only one Excel file keeping the first column (name of field) and with +200 columns with the value of the fields of each Excel files.  See below

marcusblackhill

Hey @lgl_ !

You can import all doing the replacement of the filename by the "*" and after that doing one crosstab.

Look at the example attached.

Hope that help!

mock up.yxmd