Transpose data to another sheet using macro

Hi All,

I have here a working file. The code i have embedded successfully transfer all the data to another sheet.

However, its doesn't capture the duplicate parts like from column F to K, it should be transpose everything to the Validation Sheet.


And the data from column U to Z from MFD RAW DATA DUMP should be tranpose to: Validation Sheet AC to AH column.

Can anybody help me with this?I badly needed the file since i have to check manually those hundreds of customers

Attached is the file..