How to load this combination?

[#1]

How should I do to only load the row´s that have the combination of A4 and 80g?

In this exampel I would like to get row no 1, 2, 3, 4, but not row 5 because row 5 are A4 and 100g.

I did a test with crosstable to get all the "Kolumn"-data to a single field. But from there I got stuck.

[tamilarasu · Accepted solution]

Try,

Test:
LOAD RowNo,
     Artikelnr,
     Kolumn13,
     Kolumn12,
     Kolumn11,
     Kvantitet
FROM
Paper.xlsx
(ooxml, embedded labels, table is Blad1)
Where Wildmatch(Kolumn13&Kolumn12&Kolumn11,'*A4*80g*','*80g*A4*');

Row 1 is not a combination of A4 and 80g. Let me know.

[#3]

Thanks so much. And of course you are right in that row 1 is not a correct value