I think you should use "Crosstable" to allow you transform the data durring the load script:
(First I have renamed column A in the excel sheet to Date but could have used the "@1" instead). Then the load script should be something like:
CrossTable(Terminal, Sales, 1)
LOAD Date(Date, 'dd-mm-yyyy') as Date,
(ooxml, embedded labels, table is ventas);
To explain the crosstable function you can use the help function in the script editor. But in this exampe I configured it to have all the columns included in the field "Terminal", and the values as Sales. The 1 is refering to that the first column should be a field - and not included in the cross table. Hope that will do the trick for you...