I have one business requirement, where I have been given two input excel files. You can see the below input files (dummy data are provided into the excel)
This is input excel file1
This is input excel file2
Now the bot needs to check the first input file and check the each value of Relevant Controls column, and then checks the second file where it checks in which sheet name that control name is present, and after when it is found then in that particular sheet it will check in which column that ‘X’ is present. At last add these column names in a separate excel output file.
Output Excel file
As you can see in the second file the number of columns (columns which are M.034, M.087 etc) are keep changing in different sheets.
Any suggestion on this ?