How to shape data by cell and not by column?

Hi everyone,   I hope your're well and can help the newbie I am. I need to import and compile 25 identical excel files (KPI) - my problem is that my data (indicatirs) are either percentages or num...