Hi - I am just trying to figure out the tool that helps me to pick specific columns from multiple sheets from 1 excel file and give me 1 output file consolidating that specific column. ex: A file contains sheet A, B & C have many columns. Those few columns have customer ID and Customer name but in different positions. I have to find a way to select ID and name from all three sheets and consolidate and provide one output. It is difficult for me as the sheets are not in the same format. Any help is appreciated, thanks!
Added example file and output sheet to see the expected output.
