data in Excel files

Job ID: 34254863

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.
Related categories: Visual Basic Data Processing Data Entry Excel