How to Transpose single cell data into multiple column for multiple files

Hi All,
Hope you are doing well, I have a few data files placed in a folder, when I run the macro it will open the data files one by one and will transpose the "C" cell data into the macro output sheet (sample data given in the output sheet).
I have created the macro with help of some codes but it's not working properly. Please have a look and at least provide me the code to transpose the data which can work for my macro.

attached - macro file (with sample output)
attached - data files folder (sample files which have to update in macro output sheet)
Thank you