i have problem to combine several excel file (up to 8000) to a single master file.there are several file in excel that have particular such as name, age,gender..etc in a horizontal.
Name: Sllay
Age: 23
Gender: Female
so i need to transfer the data to a new worksheet and change the data to...