Hello everyone,
I have three separate excel files that I need to filter, extract and compile it in a single excel file.
Below three are the example of the mock excel files I try to replicate based form my actual project:
First file
Second file
(this second file has an extra row of information I don’t need which I need to filter out.)
Third file
*The highlighted headers are the information I want to extract from the column
I want to output those extracted information to a new file and compile it like this:
This is the example of the output I have done manually
I tried using the merge table activity to join all three tables together but it came out with a lot of row redundancies and blank spaces, and the information are not matched and not in proper order.
Can anyone help or suggest me any other way to do this?
Thanks,
Hariz