Create a simple table like a pivot table

[#1]

Don't know how to do this ?

Thanks

[swuehl · Accepted solution]

You should create a numeric order number field in your script:

LOAD

     Order,

     keepchar(Order,'0123456789') as OrderNum,

     ...

Then you can use e.g. for 1. orders:

=FirstSortedValue(Order,OrderNum,1)

and second orders:

=FirstSortedValue(Order,OrderNum,2)

See also attached.

[#3]

Thank you very mutch. This is exactly that i want