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 · Accepted solution]

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!

[lgl_]

Safe many hours! Thanks!

[marcusblackhill]

Happy to help my friend!

Always count with the community! 🙂