Not at all. If the Order No and Line No each identify a single line, you load them first as shown (without the Amount). Afterwards you just JOIN the other columns to those so-called "Primary Key" values. Like in:
FirstSortedValue([Operation/Activity], -[Operation/Activity]) AS [Operation/Activity]
FROM QV_Load.xlsx (ooxml, embedded labels, table is Sheet1)
GROUP BY Order;
FROM QV_Load.xlsx (ooxml, embedded labels, table is Sheet1);
Very simple. But I see that you already found a solution.