The issue is the structure of your data this data is in a 'cross table' format and you need to 'uncross' it to make it easier to use. There is a function you can add in the data load editor to do this called "Cross Table". I assume your data was made up of Products and Prices but you can choose any labels that makes sense. Your script would look something like this:
CrossTable(Product, Price, 1)
FROM [lib://Desktop/Example Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
I've also included an example QVF for your reference.