data in Excel files
Budget: ₹12,500 – ₹37,500 INR
need to merge 10 Excel files and then reformat them so they are readable . This will involve moving data that is currently in a single column into rows. Then, for two of the columns, I need to add 'dummy codes'. For all other columns, I need a count of the occurrences of each code.