Selected places should come in one line.

[NaomiMariaThomson]

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

[Qiu · Accepted solution]

@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.

[NaomiMariaThomson]

Hi @Qiu 

Thank you so much for this simple solution.

It worked well for me! 

Regards,

Naomi

[Qiu · Accepted solution]

@NaomiMariaThomson 
Glad to help and thank you for your feedback.