Selected places should come in one line.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
My problem is as below:
My input files indicate an ID which has travelled to different locations.
The number of input files is not fixed, it can vary from 1 - 20+ files. I have provided 2 for this example.
However, I want the output to appear as shared in the excel file " Desired output"
If one ID has travelled to multiple locations, the 'x' in those respective location columns must all appear in one line.
Request to help me solve this.
Thanks and Regards,
Naomi
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NaomiMariaThomson
This is a very interesting one. 😁
First, I would use this macro since the files are having different schedma.
Then after reading all the record, some data processing is needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NaomiMariaThomson
Glad to help and thank you for your feedback.
