Selected places should come in one line.

Question

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

Query.zip

Qiu · Accepted Answer

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

Qiu · Accepted Answer

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