This question seems like it should be easy, for some reason I just can't think of the answer.
So I have a table that does not really have a unique key. Let's call the first column "Order" and the second column "Item_Num". There can be multiple rows for one order, each with a different Item_Num.
I want (in my script) to create an indicator based on what items are listed for one order.
If the orginal data was like this:
Order Item
1 1
2 2
2 3
3 1
3 3
I want a new table (created in the script) to look like this:
