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:
(this second file has an extra row of information I don’t need which I need to filter out.)
*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?