SOLVED
Consolidate Excel files in one
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lgl_
5 - Atom
‎12-07-2020
08:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
3 REPLIES 3
12 - Quasar
‎12-07-2020
08:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
‎12-07-2020
09:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Safe many hours! Thanks!
12 - Quasar
‎12-07-2020
09:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help my friend!
Always count with the community! 🙂
