Row to Column

[#1]

Hi,

please look at my example. I need the finale table like ...

568 / 789

One / Two

How can I achieved this?

Thanks... !

[#2]

Okay I think this is the solutions...

[#3]

!

[swuehl]

You can also achieve it using a GENERIC LOAD:

Test:

GENERIC

LOAD Recno() as Key, * INLINE [

    ID, Nummer

    564, One

    789, Two

];

The Generic Load

edit: The Key should probably just a constant in this case: LOAD 1 as Key, * INLINE [ ...