Your example does not go far enough - is row 1 always 1, regardless of order of the records, or is there a meaning to it based on for example the order of dates or other value.
i.e. from this
Value Row
A............1
B............2
C............3
do you want
Value Row
C............3
B............2
A............1
or
Value Row
C............1
B............2
A............3
Your example does not go far enough - is row 1 always 1, regardless of order of the records, or is there a meaning to it based on for example the order of dates or other value.
i.e. from this
Value Row
A............1
B............2
C............3
do you want
Value Row
C............3
B............2
A............1
or
Value Row
C............1
B............2
A............3