Are you quite sure there can never be more than 16 orders per ID ?
The form your table is in now is actually the preferred form. It's called an
associative table, and logic suggests that it sits between a table that
holds more info on the IDs, and a table that holds more info on the orders.
On M
I have a table with two columns, ID and order. Each ID can be
repeated up to 16 timers.
I need to reshape it so that I have one row per ID, and columns
order1, order 2,...order 16, and one number that lists how many orders
there actually were.
No this is not a homework assignment. I'm trying to
